The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.
The post The Lock Escalation Threshold – Part 3 appeared first on SQLServerCentral.
