You should not be updating 10k rows in a set unless you are certain that the operation is getting Page Locks (due to multiple rows per page being part of the
UPDATE
operation). The issue is that Lock Escalation (from either Row or Page to Table locks) occurs at 5000…
I need to learn more about ROW, PAGE, TABLE locks
Top comments (0)