I am working on ingesting data into TABLE A in SQL Server [ with a columnstore clustered index ]. There are 4 parallel threads of "INSERT BULK" writing into table, I am getting a deadlock error:
Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
After researching, I found out that clustered columnstore index usually get deadlock issues, but could not figure out the resolution. Can you please suggest what could be done?
Check if your db has snapshot isolation level ON. For me changing snapshot isolation level to off solved deadlocks problems on Columnstore table.