Title	When Watched
Solve Parameter Sniffing By Using Local Variables	12/13/2011
Basic MERGE statements in SQL Server 2008	6/16/2011
Performing Updates with Common Table Expressions (CTE)	6/16/2011
Using the TSQL Checksum Function	6/15/2011
Using the Database Object in SMO	5/16/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/16/2011
Tablediff - Compare Data in SQL Server Tables	3/8/2011
How to Do a Split Backup in SQL Server	2/1/2011
Use sp_MSForEachDB Instead of Your Own Loop	1/20/2011
Using SELECT to Generate SQL Commands	10/28/2010
Manipulating Hierarchies with HIERARCHYID	7/24/2009
The MERGE statement in SQL Server 2008	7/24/2009