SQL Server Code,Tips and Tricks, Performance Tuning

Here I go again linking to other people's posts instead of writing my own ;-( Louis Davidson has a nice little entry on his SQL Doctor b...

If you divide with 2 integers in SQL Server the result will be also an integer( 3/2 =1, 5/2 =2) If you need the fractions then you need to c...

Sometimes you inherit a table/database and you need to check if any of the rows in the table have columns with null values I will show you a...

Since I am still sleep deprived and can't think straight I have decided to post a link to a good article on the Tips, Tricks, and Advice...

I am a father again; my wife gave birth to 2 beautiful babies on Monday night. The boy is named Nicholas and the girl is name Catherine (yes...

Mladen has compared the following 4 methods for importing a flat file in SQl Server 2005 1. BCP 2. Bulk Insert 3. OpenRowset with BULK optio...

This popped up in a newsgroup today so I decided to do a little post about it. How do you get the time information only from a datetime valu...

Channel 9 has a cool webcast with several people talking about Visual Studio 2005 Team Edition for Database Professionals (Data Dude) From ...

Visual Studio 2005 Team Edition for Database Professionals (Data Dude) CTP 4 is available for download Brief Description Community Technolog...

Peter DeBetta and Adam Machanic have created SqlBlog.com. It has a very nice list of SQL Server blogs and if you click on roller you will s...

When you do a non updating update like the one below UPDATE t SET i = 1 WHERE i=1 In SQL 2000, the lack of the optimization leads to upda...

Sometimes you want the identity value to start from 1 again after you delete all the rows from a table There are 2 ways to accomplish that 1...

Learn how easy it is to build and debug your first SQL Server Integration Services (SSIS) Package. Donald Farmer introduces the development ...

If you're into Analysis Services, Integration Services, Reporting Services and BI in general - you'll want to check out Elizabeth Vi...

Here is an Independence Day gift for you. You can get the fast backup and recovery solution LiteSpeed for free (to be used with the develope...

I promised I would write a 'real' SQl subject so here it is: DDL triggers and DDL events for use with DDL triggers Let's start b...

Below are the top 5 posts according to Google Analytics for the month of June COALESCE And ISNULL Differences is number one, the big reason ...

These are the top SQL Searches on this site for the month of June. I have left out searches that have nothing to do with SQL Server or progr...

How do you list DDL triggers in SQL Server 2005? It's very easy you just query the sys.triggers catalog view. Let's try an example U...

Why do things break the moment that the person who handles something is on vacation? Here is the full story. A co-worker goes on vacation, h...