Press "Enter" to skip to content

Columnstore Lock Escalation

Brent Ozar is not impressed:

If you’ve got a regular rowstore table and you need to modify thousands of rows, you can use the fast ordered delete technique to delete rows in batches without hitting the lock escalation threshold. That’s great for rowstore indexes, but…columnstore indexes are different.

Click through for an example of why deleting from columnstore indexes is not something you do willy-nilly.