NULL & 'NULL'

usp_TransposeNRows v2.0

Transpose N rows of a table (v2.0 allows user to specify the table's schema)

Rowcount

Bit by bit

Query cost

Wildcard

Using "Multiple Assignment Variables" for a Generic Compare Data Script

Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.

Sound Off with Soundex

In this article, learn how to use phonetic algorithms such as soundex to make looking up names faster, easier, and more reliable.

Predict output

Script to get Server Info

This script will gather a number of Server Information items that are useful in baselining a SQL Server.