Blocking between two MERGE queries
We have a large data warehouse table partitioned on an INT column. When multiple MERGE queries are executed on this partitioned table (each focusing on different partition of the same table) they seem to be blocking each other.
Sql Server: Blocking between two MERGE queries
We have a large data warehouse table partitioned on an INT column. When multiple MERGE queries are executed on this partitioned table (each focusing on different partition of the same table) they seem to be blocking each other.