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.