SQLServerCentral » Latest topics
Lock Escalation
Hi
We are experiencing lock escalation when inserting data in SQL2012 CU 10 SP3. Data is staged in a table variable before load and then inserted using an outer join referencing the primary key to prevent duplicates from being inserted. The appli
We are experiencing lock escalation when inserting data in SQL2012 CU 10 SP3. Data is staged in a table variable before load and then inserted using an outer join referencing the primary key to prevent duplicates from being inserted. The appli
No comments:
Post a Comment