Why do we need Intent Locks in SQL Server?
I blogged 2 years ago about why we need UPDATE locks in SQL Server. Today I want to continue this discussion by talking about Intent Locks in SQL Server, and why they are needed. The Lock Hierarchy in SQL Server When I talked about Lock Escalations in SQL Server, I started by briefly mentioning that …
