Q & A – Deleting lots of rows from a huge table.
The question came up as a blog comment of “To delete 100,000 row chunks from a 9,542,067 row table, how about” Thats a great question. I have had to do something very similar lately. The problem that you run into when you are deleting 100,000 rows is lock escalation. When you run a delete statement with just a few rows …
Q & A – Deleting lots of rows from a huge table. Read more »