Title	When Watched
Using the IndexProperty Function	3/5/2010
Using @@Total_Read and @@Total_Write	3/5/2010
Using DB_ID and DB_Name Functions	3/5/2010
How to Change Database Statistics Settings	1/4/2010
Statistics & Using DBCC Show_Statistics	1/4/2010
The Impact of Stale Statistics	1/4/2010
Using sp_autostats	1/4/2010
Updating Statistics - Part 3	1/4/2010
Updating Statistics - Part 2	1/4/2010
Updating Statistics - Part 1	1/4/2010
Filegroups and Adding a New Filegroup	12/2/2009
PIVOT using the CASE statement	9/23/2009
Shredding XML Elements with the Xquery Value Function	8/20/2009
Writing Simple Select Statements	8/4/2009
Joining Tables Part 1	8/3/2009
XP_cmdshell Execution in SQL Server 2005 / 2008	8/3/2009
Data Driven Text Color with Reporting Services	8/3/2009
Testing User Defined Functions (UDF's)	8/3/2009
Cursor Query Plans	8/3/2009
Solve Parameter Sniffing by Using OPTION RECOMPILE	8/3/2009
Filtering XML Elements using the Exist Method	8/3/2009
Monitoring Exec Cache in SQL Server - Part 2	7/21/2009
Monitoring Exec Cache in SQL Server - Part 1	7/21/2009
Solve Parameter Sniffing By Using Local Variables	7/8/2009
Error Handling with UDF's	5/29/2009
Using the DTA to Assist in Performance Tuning	5/29/2009
Delete Statement Operators	5/29/2009
Tooltips in Execution Plans	5/29/2009
What is the Spool Operator?	5/28/2009
Restoring a Full Backup of a Database in SSMS	5/28/2009