SQL Server Code,Tips and Tricks, Performance Tuning

-- Create our Pivot table ** do this only once-- populate it with 1000 rows CREATE TABLE NumberPivot (NumberID INT PRIMARY KEY ) DECLARE ...

The trick to create date ranges without loops is to use a pivot table. How does this work? Run the code below and you will see, only create ...

If you have lookup tables (or other small tables) that are frequently accessed and you don’t want to reduce I/O use the command DBCC PINTABL...

Here is a link to a list of all the MS SQL Server MVP's All of them have website links next to their name Now you can see who all those ...

In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Ob...

According to Joe Celko this should always happen on the client side, but in case you ever need it (for example in DTS when you have to outpu...

Average length of all rows in a table Sometimes you want to know how much space the average row is in your table Instead of writing tedious ...

Sometimes you want to display 4 random articles/pics/you name it on your web page and you don’t want to write a lot of code. SQL SERVER 2000...

When using @@IDENTITY I get the wrong results I have seen this problem posted many times on newsgroups and It actually happened to a co-wor...