Title	When Watched
Query Plans with Update Triggers	12/14/2011
Solve Parameter Sniffing By Using Local Variables	12/14/2011
SQL Server Properties to Avoid	7/25/2011
Sparse Columns and Column Sets in SQL Server 2008	7/14/2011
Setting Deadlock Priority	7/7/2011
What is the Scalar Operator in a SQL Query Plan?	7/3/2011
Preventing SQL Injection With String Filtering	6/27/2011
SQL Server Login vs Windows Authenticated Logins	6/23/2011
Using Indexes on Tables Variables in SQL Server	6/14/2011
Reversing Deadlocking - Part 2	4/3/2011
Reversing Deadlocking - Part 3	4/3/2011
Tablediff - Compare Data in SQL Server Tables	3/8/2011
Adding SQL Agent Operators Using TSQL	2/15/2011
Setting A Database to Read Only	2/15/2011
Using Column Sets with Sparse column in SQL Server 2008	2/15/2011
Use sp_MSForEachDB Instead of Your Own Loop	2/9/2011
Reversing Deadlocking - Part 1	1/11/2011
DBCC InputBuffer - Seeing the Last Executed Command	1/1/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	12/31/2010
Get The Definition of a SQL Object Using Object_Definition	12/1/2010
Using the USE Statement	11/16/2010
SET vs SELECT For Assigning Values to Variables	10/4/2010
Using the FORCE ORDER Query Hint	9/23/2010
Using LOOP, MERGE, and HASH Join Hints	9/23/2010
Forcing Query Plans to use LOOP, MERGE, and HASH Joins	9/23/2010
Explaining The Properties Window in SQL Server Profiler	8/29/2010
How To Restore Using a Differential Backup & TSQL	7/31/2010
Differential Backup and Restore of a SQL Server Database (Full Recovery)	7/31/2010
Doing a Differential Backup of a SQL Server Database (Simple Recovery)	7/15/2010
How to do a Copy Only Backup of a SQL Server Database	7/14/2010