Forum Discussion
AndyDDC
1 year agoMost Valuable Professional
Re: 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