Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, December 6, 2017

Is there a safe way to use SqlBulkCopy across multiple threads?

SQLServerCentral » Latest topics
Is there a safe way to use SqlBulkCopy across multiple threads?
We've introduced SqlBulkCopy on a batch job that executes across multiple threads but are now getting intermittent deadlocks.

- We're not using the table lock option.
- The table being inserted has a clustered index.
- Each thread

No comments: