Title	When Watched
PIVOT using the PIVOT statement	8/12/2011
What is the Scalar Operator in a SQL Query Plan?	6/30/2011
Using Indexes on Tables Variables in SQL Server	6/28/2011
How to Detect Deadlocking in SQL Server - Part 3	1/11/2011
How to Detect Deadlocking in SQL Server - Part 2	1/11/2011
Reversing Deadlocking - Part 1	1/11/2011
Using WITH RECOMPILE With a Stored Procedure - Part 1	9/30/2010
Using a CTE to Update With An Aggregate Expression	9/30/2010
Using the Identity Function	9/30/2010
Speak Like a SSIS Developer	9/30/2010
Introduction to Common Table Expressions	9/30/2010
Using a Sort Transform in SSIS	9/17/2010
Joining Tables Part 1	9/17/2010
Exploring the Sys.Stats and Sys.StatColumns Tables	9/8/2010
Methods to Import/Export SSIS Packages	8/12/2010
SSIS Lookup Transform - Lookup Failures	7/1/2010
SSIS Lookup Transform Basics	7/1/2010
Looping Through and Loading Files with SSIS	7/1/2010