Title	When Watched
Collections Explained	1/26/2012
Multi Statement Query Plans	1/3/2012
Text Query Plans	12/5/2011
SQL Server Table Scans	12/5/2011
Using Client Statistics	12/5/2011
SQL Server System Functions	11/29/2011
Filtered Indexes in SQL Server 2008	11/29/2011
Using Database DDL Triggers	11/23/2011
Query Plans with Update Triggers	11/23/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	10/21/2011
Compound Assignments in SQL Server 2008	10/21/2011
Using Column Sets with Sparse column in SQL Server 2008	10/21/2011
How to Fix a Bookmark Lookup	10/19/2011
The Key Lookup Operator in SQL Server Query Plans	10/19/2011
Create an Asymmetric Key in SQL Server 2005 / 2008	8/16/2011
What are the Statistics IO?	8/8/2011
Reversing Deadlocking - Part 1	8/2/2011
User Defined Function Tips	8/2/2011
What is the Scalar Operator in a SQL Query Plan?	6/30/2011
Row Concatenation Using FOR XML PATH	4/25/2011
Building SQL Job Schedules	4/12/2011
Capture Schema Changes with SMO	4/7/2011
Breakpoints in SSIS	3/17/2011
Using ClearTrace to Analyze Profiler Results	3/2/2011
Renaming Views - Part 2	2/15/2011
Renaming a View - Part 1	2/14/2011
Creating a Performance Counter Log	2/1/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	9/23/2010
Introduction to Plan Caching and SysCacheObjects	9/23/2010
Forcing Query Plans to use LOOP, MERGE, and HASH Joins	9/23/2010