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

T-SQL

Comparing Stored Procedures, Part 3

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

Complicated Comments

T-SQL