Headaches of Blocking, Locking, and Deadlocking

It strikes fear in your heart: "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim." Learn the basics of how SQL Server handles blocking, locking, and deadlocking as Microsoft Certified Master Brent Ozar demos LCK% waits and deadlocks, then shows how to fix them with query changes, index improvements, and isolation level tweaks.