Title	Published Date
Creating Missing Indexes	2/23/2009

Title	When Watched
Methods to Import/Export SSIS Packages	8/10/2010
Using Hashbytes in SQL Server 2005 / 2008	8/9/2010
Using OPTION RECOMPILE for Statement Level Recompilation	8/2/2010
Clearing the Procedure Cache	7/29/2010
Introduction to Plan Guides	7/27/2010
Intersect Operator	7/6/2010
Except Operator	7/6/2010
Solve Parameter Sniffing By Using Local Variables	6/24/2010
Using Client Statistics	6/21/2010
Performance Tuning Quiz #3 - Part 2	6/2/2010
Performance Tuning Quiz #3 - Part 1	6/1/2010
Reporting Service Subscriptions & The DBA	5/26/2010
Creating Missing Indexes	5/23/2010
Performance Tuning Quiz #2 - Part 1	5/19/2010
How to Detect Deadlocking in SQL Server - Part 1	4/20/2010
GUID or INT for Primary Key - A Mostly Unbiased Discussion	4/12/2010
Using DatePart and DateName	3/11/2010
Statistics & Using DBCC Show_Statistics	12/17/2009
Understanding DBCC Show_Statistics	12/14/2009
Statistics Based on Indexes	12/14/2009
Introduction to Statistics	12/9/2009
Introduction to SQL Jobs	11/16/2009
SysAdmin vs DBO vs DB Owner in SQL Server	7/20/2009
Monitoring Exec Cache in SQL Server - Part 1	7/16/2009
Data Access with Scalar UDF's	7/14/2009
User Defined Functions Metadata	7/10/2009
Enumerate SQL Server Databases using SMO	6/30/2009
Basic Formatting with SQL Server Reporting Services	6/29/2009
What is the Distinct Operator?	6/25/2009
Unpivot Data Using the UNPIVOT Function in SQL Server	6/22/2009