I am facing deadlock issue in the SQL Server. I have two process using the same table at same time. first process will insert the records using bulk insert and second process will update the records in the same table.
Please could you let me know how can avoid deadlock.
What I have tried:
I found Bulk insert will create tab lock on the table.