Locking in Microsoft SQL Server (Table of Content)
Just to make it simpler to navigate:
- Part 1: Major Lock Types
- Part 2: Locks and Transaction Isolation Levels
- Part 3: Blocking in the system
- Part 4: How to detect blocking
- Part 5: Deadlocks
- Part 6: How to troubleshoot deadlocks
- Part 7: (Interlude) - Read Committed - duplicate reading
- Part 8: Optimistic isolation levels
- Part 9: Optimistic isolation levels - TANSTAAFL!
- Part 10: What isolation level should I choose?
Additional: