SELECT setter

Curiouse View to create for SQLServer 2005

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.

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.