Title	When Watched
Sparse Columns in SQL Server 2008	8/24/2012
Reporting Services Formatting Codes	3/19/2012
Designing a KPI in Report Services	3/19/2012
Computed Columns - Part 1	3/19/2012
Use sp_MSForEachDB Instead of Your Own Loop	3/19/2012
How to Find Blocked Processes in SQL Server - Part 2	9/20/2011
How to Find Blocked Processes in SQL Server - Part 1	9/20/2011
Reversing Deadlocking - Part 3	9/20/2011
Reversing Deadlocking - Part 2	9/20/2011
Reversing Deadlocking - Part 1	9/20/2011
Execution Plan Operator Properties	9/20/2011
Using the DTA to Assist in Performance Tuning	8/17/2011
PIVOT using the PIVOT statement	8/17/2011
Create an Asymmetric Key in SQL Server 2005 / 2008	8/17/2011
Using Indexes on Tables Variables in SQL Server	8/17/2011
Using a UDF in a Computed Columns	8/17/2011
Identifying Bad XML Data in Text Data Types	8/2/2011
Performing Updates with Common Table Expressions (CTE)	8/2/2011
Using the TIMESTAMP data type in SQL Server	8/2/2011
User Defined Function Tips	8/2/2011
You Can't Do That with UDF's	7/18/2011
Explaining The Properties Window in SQL Server Profiler	7/18/2011
Creating Primary Indexes on XML Data Types in SQL Server	5/6/2011
Using the QUOTENAME Function	5/6/2011
Getting Good Performance using SOUNDEX	5/6/2011
Using SOUNDEX and DIFFERENCE	5/5/2011
UNION and UNION ALL	5/5/2011
Generating SQL Server Scripts using SMO	5/5/2011
What is an Identity Gap?	5/5/2011
Using the STUFF Function	11/8/2010