Fixing Locking and Blocking Issues in SQL Server - Part 6 - Avoiding Deadlocks
This is part 6 in a series of posts:
- Part 1 covered being sure there is a locking and blocking issue
- Part 2 covered the impact of RCSI
- Part 3 looked at the impacts of indexing on locking and blocking
- Part 4 looked at what deadlocks really are and how SQL Server handles them
- Part 5 looked at how applications should handle deadlocks
Today, though, I want to look at how to try to avoid deadlocks in the first place.
2019-05-23