Title	When Watched
Using Column Sets with Sparse column in SQL Server 2008	2/15/2012
The Execution Plan for UNION	12/2/2011
Formatting SSAS Measures	10/17/2011
Delete Statement Operators	8/22/2011
Adding a Time Stamp to a File Name in SSIS	7/14/2011
SQL Server Properties to Avoid	6/29/2011
Row Value Constructors in SQL Server 2008	5/27/2011
How to Fix a Bookmark Lookup	5/25/2011
Row Concatenation Using FOR XML PATH	5/17/2011
Using OPENXML in SQL Server	5/9/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	5/9/2011
What is an Identity Gap?	4/26/2011
Capture Schema Changes with SMO	4/6/2011
Managing the SSIS Service	3/14/2011
Adding a Custom Subject Line to a Data Driven Subscription	3/2/2011
SQL Server Profiler Templates	2/10/2011
Sparse Columns in SQL Server 2008	1/28/2011
Reversing Deadlocking - Part 3	1/13/2011
Reversing Deadlocking - Part 2	1/12/2011
Reversing Deadlocking - Part 1	1/12/2011
Converting a Text Data Type to an XML Data Type	1/7/2011
Views, Indexed Views, and NOEXPAND	12/20/2010
Get The Definition of a SQL Object Using Object_Definition	12/1/2010
A Quick Look at View Expansion	11/30/2010
Compound Assignments in SQL Server 2008	11/9/2010
Performing Updates with Common Table Expressions (CTE)	11/9/2010
Using SELECT to Concatenate Strings Across Rows	10/21/2010
Solve Parameter Sniffing By Using Optimize for Unknown	10/8/2010
Manually Creating and Dropping Statistics	9/10/2010
Controlling Plan Guides	8/31/2010