DEV Community


Posted on

Answer: How to update large table with millions of rows in SQL Server?

  1. 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)