如需獲得最佳網頁瀏覽體驗,請使用 IE 11 或更高版本、Chrome、Firefox 或 Safari。

Avoiding Deadlocks with Query Tuning

Avoiding Deadlocks with Query Tuning
在线

Oct.

15

  • 日期:Oct. 15, 2020
  • 时间: 12:00 PM – 1:00 PM EST
  • 持续时间:60 分钟
  • 位置:WebEx
  • 活动:在线
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.