Deadlocks: Lets Do One, Understand It, and Fix It

You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it.

I'm Brent Ozar, and I can help. I'll show you how to build a deadlock in just a few lines of T-SQL so you can see how SQL Server reacts. You'll be more comfortable with the decisions SQL Server takes, and when you can safely ignore 'em.

When you can't ignore 'em, you'll learn how to analyze them with free tools (sp_BlitzLock and SentryOne Plan Explorer), and how to fix them with index and code changes.