Forum Discussion
AndyDDC
Most Valuable Professional
2 years agoRe: concurrency lock condition error when writing multiple records to an audit log table simultaneously.
Hi Anonymous are you using the Warehouse service? It uses snapshot isolation and has only table level locking. Concurrent UPDATE statements will likely cause issues. I explain further here:
https://www.serverlesssql.com/transaction-isolation-in-fabric-warehouses/
No RepliesBe the first to reply