Title	When Watched
Using Indexes on Tables Variables in SQL Server	11/14/2010
Sparse Columns in SQL Server 2008	11/2/2010
Using the QUOTENAME Function	11/2/2010
Working With Nulls in SQL Server	10/29/2010
Using IF and ELSE in TSQL - The Basics of Conditional Logic	10/29/2010
Using SELECT to Generate SQL Commands	10/29/2010
Creating Indexed Views	10/29/2010
Creating Stored Procedures	10/29/2010
Joining Tables Part 1	10/28/2010
Left Join Operators	10/28/2010
Row Concatenation Using FOR XML PATH	10/28/2010
Using FOR XML with SQL Server	10/28/2010
String Handling Functions Part 7	10/28/2010
String Handling Functions - Part 5	10/28/2010
String Handling Functions - Part 4	10/28/2010
String Handling Functions - Part 3	10/28/2010
String Handling Functions - Part 2	10/28/2010
String Handling Functions - Part 1	10/28/2010
Using the SPACE and REPLICATE String Functions	10/28/2010
Using ASCII, CHAR, UNICODE, and NCHAR	10/28/2010
PIVOT using the CASE statement	10/28/2010
Introduction to the CASE Expression	10/28/2010
Using SELECT to Concatenate Strings Across Rows	10/28/2010