SQL Server Locking, Blocking, And Deadlocks
Information on SQL Server Locking and Blocking - How to detect, manage and kill blockers - Sample T-SQL code for blocking alerts
#6 - Test Environment *
#12 - Delete Command
#13 - Group By - Part 1
#14 - Group By - Part 2
#15 - Looping
#16 - Aliasing In T-SQL
#20 - Stored Procedures