Title	When Watched
SET vs SELECT For Assigning Values to Variables	3/4/2011
Working With Nulls in SQL Server	3/4/2011
Converting a Text Data Type to an XML Data Type	3/4/2011
Forcing Query Plans to use LOOP, MERGE, and HASH Joins	3/1/2011
Using LOOP, MERGE, and HASH Join Hints	3/1/2011
Using the FORCE ORDER Query Hint	2/18/2011
Enhancing Searching of Full Text Indexes	2/18/2011
Using the OPTION HASH GROUP and OPTION ORDER GROUP Query Hints	2/18/2011
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	2/14/2011
Using the OPTION FAST Query Hint	2/14/2011
Which Indexes Are Used By My Query?	2/14/2011
Controlling Plan Guides	2/7/2011
Using Index Hints in a Query	2/7/2011
Creating a Plan Guide for a Parameterized Statement	2/7/2011
PIVOT using the CASE statement	2/3/2011
Forced Parameterization for Queries in a Database	2/3/2011
Understanding Facts and Dimensions in SQL Server	2/2/2011
XP_cmdshell Execution in SQL Server 2005 / 2008	2/2/2011
Except Operator	12/14/2010
Intersect Operator	12/14/2010
Solve Parameter Sniffing By Using Local Variables	12/14/2010
Ranking Functions - NTILE (Part 4)	11/18/2010
Ranking Functions - DENSE_RANK (Part 3)	11/18/2010
Ranking Functions - Rank (Part 2)	11/18/2010
Ranking Functions - Part 1	11/18/2010
Performance Tuning Quiz #3 - Part 2	10/27/2010
Performance Tuning Quiz #3 - Part 1	10/27/2010
Performance Tuning Quiz #2 - Part 2	10/27/2010
Performance Tuning Quiz #2 - Part 1	10/27/2010
Performance Tuning Quiz - Part 3	10/26/2010