Press "Enter" to skip to content

Why Large Data Updates in SQL Server Can Be Slow

Erik Darling jumps to the heart of the issue:

How many times have you seen something like this?

You can replace “Update” with “Insert” or “Delete”, but the story is the same.

Large modifications are typically not fast modifications, for a number of reasons. To understand why, we need to think about the process as a whole.

Click through for several possible reasons.