DEV Community

loading...

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

boyukbas profile image baris ・1 min read
  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

Discussion (0)

pic
Editor guide