Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 BU lock

Author  Topic 

yogibaba
Starting Member

2 Posts

Posted - 2013-03-20 : 03:03:24
Hi All,

In our application we have a synch up process which performs large table inserts, updates and deletes.

This is done in the below order
1. Delete
2. Inserts
3. Updates.

This activity we wanted to perform in multithreaded.
We found to go for row level locking. But i found that BU lock enable to Bulk coping by parallel threads. Can this be extended for delete and update operations.

Thanks.


Baba
   

- Advertisement -