• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

bulk-logged & BEGIN TRAN

if there are many DML/DDL inside a transaction, they all have to logged, and even keeping it at BULK-LOGGED mode does not help. There is no alternative to alleviate this, is there?

thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
chapmandewCommented:
Insert statements by themselves do not benefit from bulk logged. Gotta use bulk insert.
0
 
anushahannaAuthor Commented:
ok. what about bulk insert inside a transaction that is not yet committed. how does it handle the log in such cases?
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now