SQLTeam.com | Weblogs | Forums

SQL server partition locking


Hi many thanks.

I have one problem. We did range partition of a table and when we tried to update/delete on same table but on different partitions at the same, its locking even though the lock escalation set as AUTO. But I am expecting I should be able update / delete on multiple partitions at the same for a table as long as we are dealing only that range data?

Am I missing here something? Please help.