Title	When Watched
Using the KILL Statement	1/24/2011
Get the Name - Using the OBJECT_NAME Function	12/3/2010
Creating a Performance Counter Log	11/26/2010
Using Indexes on Tables Variables in SQL Server	11/12/2010
Using SOUNDEX and DIFFERENCE	11/4/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	9/14/2010
Creating a Plan Guide for a Parameterized Statement	9/1/2010
Explaining The Properties Window in SQL Server Profiler	8/24/2010
Using WITH RECOMPILE With a Stored Procedure - Part 1	8/18/2010
Clearing the Procedure Cache	7/29/2010
Differential Backup and Restore of a SQL Server Database (Full Recovery)	7/16/2010
Except Operator	7/2/2010
Performance Tuning Quiz #3 - Part 2	5/27/2010
Reporting Service Subscriptions & The DBA	5/26/2010
Building a Report Viewer Application - Part 1	5/13/2010
Generating a Graphical Query Plan	5/13/2010
How to Detect Deadlocking in SQL Server - Part 2	5/11/2010
How to Detect Deadlocking in SQL Server - Part 1	4/19/2010
NewID vs NewSequentialID - Understanding Your UniqueIdentifier Options	4/9/2010
SSRS: Information about Report Execution History	4/7/2010
Using SPIDS	3/23/2010
Writing to the Registry from TSQL Using XP_Instance_RegWrite	3/18/2010
Identifying and Re-running Failed Reporting Services Subscriptions	2/12/2010
Using @@Identity	2/9/2010
SQL Server Properties to Avoid	1/28/2010
Error Handling in Transactions with Begin Try	1/20/2010
Error Handling in Transactions using SET XACT_ABORT	1/19/2010
Error Handling in Transactions Using @@Error	1/15/2010
Using sp_autostats	1/4/2010
Statistics & Query Optimization	12/23/2009