Title	When Watched
Shredding XML Elements with the Xquery Value Function	1/11/2012
Inline Variable Initialization in SQL Server 2008	11/8/2011
Using the Sysprocesses View	9/23/2011
Error Handling in Transactions using SET XACT_ABORT	9/23/2011
Inline UDF's in SQL Server	9/23/2011
Error Handling with UDF's	9/23/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	9/20/2011
Using the OPTION FAST Query Hint	9/20/2011
Execution Plan Operator Properties	9/20/2011
Solve Parameter Sniffing By Using OPTIMIZE FOR	9/19/2011
Handling Division by Zero with NULLIF	9/7/2011
Solve Parameter Sniffing by Using A Plan Guide	9/7/2011
Reversing Deadlocking - Part 1	7/19/2011
Adding a Time Stamp to a File Name in SSIS	7/14/2011
How to Detect Deadlocking in SQL Server - Part 3	7/7/2011
How to Detect Deadlocking in SQL Server - Part 1	7/7/2011
Implementing Hyperlinks in Reporting Services	7/6/2011
Sparse Columns in SQL Server 2008	6/21/2011
Row Concatenation Using FOR XML PATH	6/20/2011
Using the TSQL Checksum Function	6/15/2011
Using OPENXML in SQL Server	5/12/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	5/9/2011
Extracting T-SQL Events from SQL Server Profiler	4/22/2011
Forcing Query Plans to use LOOP, MERGE, and HASH Joins	10/21/2010
Using Index Hints in a Query	9/9/2010
Divide and Conquer Transactional Replication using Tracer Tokens	8/3/2010
Using OPTION RECOMPILE for Statement Level Recompilation	8/2/2010
Creating a Replication Publication	7/30/2010
Creating a Replication Subscription	7/30/2010
Forced Parameterization for Queries in a Database	7/29/2010