Title	When Watched
Restoring a Compressed Backup	2/7/2011
Using Backup Compression in SQL Server	2/2/2011
Creating a Performance Counter Log	2/1/2011
How to Do a Split Backup in SQL Server	2/1/2011
Using Column Sets with Sparse column in SQL Server 2008	1/26/2011
Adding SQL Agent Operators Using TSQL	1/25/2011
Bypassing Blocking using NOLOCK	1/19/2011
Reversing Deadlocking - Part 3	1/13/2011
Reversing Deadlocking - Part 2	1/12/2011
Reversing Deadlocking - Part 1	1/11/2011
Blocking, SP_Who, and SysProcesses	1/10/2011
Options for Displaying Query Results in SSMS	1/7/2011
SP_Who & SP_Who2	1/6/2011
Using the Sysprocesses View	1/5/2011
Using a UDL File for Database Connectivity Testing	1/3/2011
SQL Server System Functions	12/30/2010
DBCC InputBuffer - Seeing the Last Executed Command	12/30/2010
What is a Trivial Execution Plan?	12/28/2010
How to Fix a Bookmark Lookup	12/28/2010
What are the Statistics IO?	12/28/2010
Using the DTA to Assist in Performance Tuning	12/28/2010
Introduction to Plan Caching and SysCacheObjects	12/28/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	12/28/2010
Creating Hierarcies with HierarchyId in SQL Server 2008	12/27/2010
Using SET LANGUAGE	12/22/2010
Using DatePart and DateName	12/22/2010
PIVOT using the PIVOT statement	12/14/2010
CONVERT - Changing a Date to a String	12/14/2010
Using CONVERT - String Literals to Date Data Types	12/13/2010
Using sp_HelpText To View Object Defintions	12/7/2010