Title	When Watched
Using a CTE to Update With An Aggregate Expression	7/23/2010
Introduction to Common Table Expressions	7/23/2010
Using SPIDS	7/23/2010
Capturing the Output of a Job Step	6/3/2010
Using DatePart and DateName	6/3/2010
Renaming a Database	6/3/2010
Using the IndexProperty Function	6/3/2010
Using the Object_ID Function	6/3/2010
Ranking Functions - Part 1	6/3/2010
Performance Tuning Puzzle - Part 1	5/25/2010
Updating Statistics - Part 3	5/17/2010
Updating Statistics - Part 2	5/17/2010
Introduction to Statistics	5/17/2010
How to Change Database Statistics Settings	5/17/2010
Updating Statistics - Part 1	5/17/2010
Understanding DBCC Show_Statistics	5/17/2010
Using the StatsDate Function	5/17/2010
Using sp_autostats	5/17/2010
SQL Server Data File Extensions	4/6/2010
How to Change the Default Path for New Databases	3/23/2010
Using XP_Instance_RegRead To Get Default Database Path	3/23/2010
Looping Through and Loading Files with SSIS	3/9/2010
Tablediff - Compare Data in SQL Server Tables	3/9/2010
Using Truncate Table	2/22/2010
Using a Server Trigger to Dropping a Database	2/22/2010
Using Set Rowcount	2/22/2010
Error Handling in Transactions with Begin Try	2/22/2010
Using @@Trancount in Transactions	2/22/2010
Use SSMS to Help Script Tasks	2/22/2010
How to Move Database Diagrams in SQL Server 2005-2008	2/22/2010