Browse by Tags

All Tags » SQL (RSS)
Friday, May 02, 2008 11:50 AM

SQL Saturday Jax May 3 2008

Tomorrow will be the long awaited third installment of SQL Saturday in Jacksonville FL. I want to thank Brian, Andy and the team for all their hard work putting the event together. If you attended my talk or just want to see some cool stuff about using...
Posted by sweisfeld | with no comments
Filed under:
Friday, April 25, 2008 2:55 PM

Need to delete lots of data, do it in small chunks

By adding a top clause to your delete statement you can delete a chunk of records at a time. By combining it with a while you can put it in a loop and wipe the entire table. WHILE EXISTS ( SELECT * FROM Foo ) BEGIN DELETE TOP ( 100 ) FROM Foo END Had...
Posted by sweisfeld | with no comments
Filed under:
Saturday, April 12, 2008 6:03 PM

Drop Me!

I was trying to get rid of all the objects (tables, procedures, views) in my database and whipped up this little script and while it is far from perfect it is well worth sharing. . . SELECT CASE WHEN type = 'P' THEN 'DROP PROCEDURE ' ...
Posted by sweisfeld | with no comments
Filed under:
Sunday, February 17, 2008 6:56 PM

2008 SQL Saturday Tampa

SQL Saturday Tampa 2008 was great, a big thank you to the organizers Pam, Wes, and team, great job guys! To those that attended my session on the SQL CLR I have uploaded my presentation here ( http://cid-afc22ba66ea68f7d.skydrive.live.com/self.aspx/Public...
Posted by sweisfeld | with no comments
Filed under: , ,
Monday, January 21, 2008 8:55 AM

Pivot/Cross Tab Queries in SQL Server

There are many ways to turn rows of data into columns in SQL Server, I figured I would outline some of them and talk about some of the pro/cons of each. Sample 1: Using the SQL Server 2005 PIVOT operator. This is a great feature of SQL Server 2005 but...
Posted by sweisfeld | with no comments
Filed under:
Sunday, November 11, 2007 12:37 PM

Orlando SQL Saturday 2007 & .NET SQL CLR

Yesterday was the first ever SQL Saturday, mad props to Andy Warren from End2End Training ( http://www.endtoendtraining.com/ ) for all his work organizing this event. Over 200 people showed up to hear about some SQL server goodness. Andy defiantly raised...
Posted by sweisfeld | with no comments
Filed under: ,
Friday, October 26, 2007 3:14 PM

SQL Server 2005 Bulk Inserts

Need to dump a large amount of data into sql server? Have I got some tools for you! Recently I needed to, from a stored procedure, copy a large amount of data from a text file on the disk into my sql server. This is nice an easy with SQL Server 2005....
Posted by sweisfeld | with no comments
Filed under: ,
Tuesday, October 16, 2007 6:34 AM

Creating a Green-Bar (Zebra Stripe) Report on Groups in Reporting Services

Question: How do you create a green-bar (zebra stripe) report using groups in reporting services? Answer: I have seen many examples of creating green-bar reports where each record alternated colors. All one has to do is add a row_number field to their...
Posted by sweisfeld | with no comments
Filed under: ,
Tuesday, August 21, 2007 5:11 PM

Flatten a Hierarchy in SQL Server 2005

Hierarchies are common in many applications today. Some classic examples are the reporting chain in your company. For example you are an employee and you report to another employee and that employee. A common way to represent this is utilizing an "Adjacency...
Posted by sweisfeld | with no comments
Filed under: ,
Wednesday, August 08, 2007 10:13 PM

Other Orlando UG’s & TSQL Random Raffle Picker

So this has been a busy week for me. Tuesday I went to my first Orlando SQL Server UG meeting ( http://www.opass.org ) and Wednesday I went to the first Orlando SharePoint UG meeting ( http://www.mossmosis.com/schedule_orlando.html ). A big thumbs up...
Posted by sweisfeld | with no comments
Filed under: ,
Saturday, June 09, 2007 9:39 AM

Notes from the TechEd 2007 Birds of a Feather I did with Alan

Shawn Weisfeld C# MVP President Orlando .NET Users Group http://www.shawnweisfeld.com shawn@shawnweisfeld.com Alan Stevens President East Tennessee .NET Users Group alanstevens@gmail.com http://netcave.org/ Notes by Dave Noderer: daven@computerways.com...
Posted by sweisfeld | with no comments
Filed under: , , , , ,
Friday, January 19, 2007 11:08 AM

My DataHelper

While I am a firm believer in the Enterprise Application Blocks from Patterns and Practices ( http://msdn.microsoft.com/practices ) I was recently asked to produce a simple way for people to get data without the EAB. I know there are a million examples...
Posted by sweisfeld | with no comments
Filed under: , , ,
Thursday, December 07, 2006 5:25 PM

Help with SSIS

UPDATE : it appears to work fine when the physical path to the file is replaced with a file share path (i.e. " \\machine\files\xxx.txt ") I recently posted the following question to the Microsoft Newsgroup. If you have any ideas please post a reply to...
Posted by sweisfeld | with no comments
Filed under: ,
Monday, November 06, 2006 2:52 PM

SQL Server 2005 DDL Event Logging

Wouldn’t it be nice to have a record of every DDL (structural) change to your SQL Server? Well you can do it very easily in SQL Server 2005. Microsoft has even provided you the script to do it, aren’t they nice. (How about just creating a check box to...
Posted by sweisfeld | with no comments
Filed under: