Title	When Watched
Inline Variable Initialization in SQL Server 2008	11/8/2011
Using Column Sets with Sparse column in SQL Server 2008	11/8/2011
Compound Assignments in SQL Server 2008	11/8/2011
Basic MERGE statements in SQL Server 2008	11/8/2011
SQL Server 2005 / 2008 XML Data Type	3/15/2011
Using OPENXML in SQL Server	3/15/2011
Ranking Functions - Rank (Part 2)	6/24/2010
Ranking Functions - Part 1	6/24/2010
Using DatePart and DateName	3/11/2010
Using the IndexProperty Function	2/26/2010
Using the Object_ID Function	2/25/2010
Cursor Query Plans	8/3/2009
What is the Distinct Operator?	6/25/2009
The Execution Plan for UNION	6/23/2009
Insert Statement Operators	5/27/2009
What is the Spool Operator?	5/27/2009
PIVOT using the CASE statement	5/15/2009
What is an Index Seek Operator?	5/14/2009
What is the Count Operator?	5/13/2009
SQL Injection Explained	5/11/2009
Try Catch Blocks and Return Values within SMO	5/7/2009
What is the Group By Operator?	5/6/2009
Execution Plan Operator Properties	4/28/2009
PIVOT using the PIVOT statement	3/18/2009
Honeycombing in SQL Server 2008	3/2/2009
What is a Nested Loop Join Operator?	2/5/2009
What is the Scalar Operator in a SQL Query Plan?	1/26/2009
The execution plan for UNION ALL	11/25/2008
What is a Hash Match Join Operator?	11/12/2008
Left Join Operators	11/6/2008