Information on SQL Server Locking and Blocking - How to detect, manage and kill blockers - Sample T-SQL code for blocking alerts