Title	When Watched
Renaming a Database	3/10/2010
Using the IndexProperty Function	2/26/2010
Using the ServerProperty Function	2/19/2010
Using Truncate Table	2/17/2010
Using Top N with Percentages	2/10/2010
Use SSMS to Help Script Tasks	2/10/2010
Dynamic SQL Using sp_executesql	2/10/2010
Using the StatsDate Function	2/10/2010
Error Handling in Transactions Using @@Error	2/10/2010
Using @@Trancount in Transactions	2/10/2010
Using a UDL File for Database Connectivity Testing	2/10/2010
Using @@Version and xp_MSVer to Get Your SQL Version	2/10/2010
Using Identity Insert to Insert Rows	2/10/2010
Using the Identity Function	2/10/2010
Using @@Identity	2/10/2010
Error Handling in Transactions with Begin Try	1/20/2010
PIVOT using the PIVOT statement	1/18/2010
Using sp_autostats	1/5/2010
SQL Server Internals: Hardware and processes	1/4/2010
Updating Statistics - Part 3	1/4/2010
PIVOT using the CASE statement	12/31/2009
Updating Statistics - Part 2	12/30/2009
Statistics & Query Optimization	12/23/2009
Tablediff - Compare Data in SQL Server Tables	12/22/2009
The Impact of Stale Statistics	12/22/2009
Statistics Based on Indexes	12/15/2009
Understanding DBCC Show_Statistics	12/15/2009
How to Change Database Statistics Settings	12/15/2009
Introduction to Statistics	12/9/2009
Filegroups and Adding a New Filegroup	12/2/2009