Title	When Watched
Unpivot Data Using the UNPIVOT Function in SQL Server	9/21/2011
Solve Parameter Sniffing By Using OPTIMIZE FOR	9/19/2011
Customizing the Full Text Search Thesaurus	9/18/2011
Tooltips in Execution Plans	8/26/2011
Creating Primary Indexes on XML Data Types in SQL Server	7/6/2011
Rebuilding SQL Server Indexes Using SMO	6/8/2011
Using OPENXML in SQL Server	6/3/2011
Table Valued Parameters in SQL Server 2008	6/2/2011
Identifying Bad XML Data in Text Data Types	5/27/2011
The MERGE statement in SQL Server 2008	5/27/2011
Composable DML in SQL Server 2008	5/27/2011
PIVOT using the PIVOT statement	5/27/2011
Row Value Constructors in SQL Server 2008	5/27/2011
Ranking Functions - NTILE (Part 4)	5/26/2011
Computed Columns - Part 2	5/26/2011
Computed Columns - Part 1	5/26/2011
Using the FORCESEEK Query Hint	5/26/2011
Blocking, SP_Who, and SysProcesses	5/26/2011
Creating a Full Text Search Catalog	5/26/2011
Using the RAND Function	2/22/2011
Using sp_HelpText To View Object Defintions	2/22/2011
Setting A Database to Read Only	2/22/2011
How to Do a Split Backup in SQL Server	2/22/2011
Loading Binary Files into SQL Server Using SSIS	2/22/2011
Detecting Deadlocks with SQL Server Profiler	2/10/2011
Joining Tables Part 1	11/19/2010
Ranking Functions - Part 1	11/19/2010
Controlling Plan Guides	11/19/2010
Row Concatenation Using FOR XML PATH	11/19/2010
What is a Merge Join Operator?	11/9/2010