Title	When Watched
Viewing SQL Server Indexes using SMO	4/28/2011
What is an Index Seek Operator?	4/12/2011
What is an Index Scan?	4/12/2011
What is the Scalar Operator in a SQL Query Plan?	4/12/2011
What is a Clustered Index Scan?	4/12/2011
SQL Server Table Scans	4/12/2011
What is a Clustered Index Seek?	4/12/2011
Statistics & Query Optimization	4/12/2011
Which Indexes Are Used By My Query?	4/12/2011
Using TableDirect with SQL Compact	5/27/2010
Solve Parameter Sniffing By Using Optimize for Unknown	10/1/2009
Creating an Analysis Services Data Source and Dataset in SSRS	9/14/2009
How to Use the SQL Server 2008 Audit Object	8/25/2009
How to Find Blocked Processes in SQL Server - Part 2	8/17/2009
How to Find Blocked Processes in SQL Server - Part 1	8/17/2009
How to Detect Deadlocking in SQL Server - Part 3	8/17/2009
How to Detect Deadlocking in SQL Server - Part 2	8/17/2009
How to Detect Deadlocking in SQL Server - Part 1	8/17/2009
Multi Statement Query Plans	8/12/2009
Using Client Statistics	7/1/2009
What is the Distinct Operator?	6/25/2009
The Execution Plan for UNION	6/23/2009
Using the File System Task in SSIS	6/17/2009
Using Checkpoints in SSIS	6/12/2009
Using the Aggregrate Transform for Group Bys in SSIS	6/12/2009
Adding a Windows Based Login to SQL Server	5/30/2009
Using the Fuzzy Lookup Transform	5/30/2009
Applied Fuzzy Lookup	5/30/2009