For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Avoiding Deadlocks with Query Tuning

Avoiding Deadlocks with Query Tuning
Online

Oct.

15

  • Date:Oct. 15, 2020
  • Time: 12:00 PM – 1:00 PM EST
  • Duration:60 Minutes
  • Location:WebEx
  • Event:Online
Avoiding Deadlocks with Query Tuning

Speaker: Brent Ozar 

The next biggest cause of deadlocks is working through tables in long transactions. You'll learn why you need to work through tables in a consistent order and touch them as few times as possible, then we'll rewrite a stored procedure that's having deadlocking problems.