SQL Server 2005 Paging – The Holy Grail

Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.

T-SQL Functions

DateAdd Function

The Safe and Easy Way to Delete All Data in a SQL Server DB

Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.

Identity Insert

Comparing Stored Procedures, Part 6

Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures

Comparing Stored Procedures, Part 5

Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures

Inserting Markup into a String with SQL

In which Phil illustrates an old trick using STUFF to intert a number of substrings from a table into a string, and explains why the technique might speed up your code...

Performance Testing Script

Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures

Find failed SQL Jobs

Simple T-SQL to find failed SQL Agent jobs