Solved

bulk-logged & BEGIN TRAN

Posted on 2010-08-13
2
395 Views
Last Modified: 2012-05-10
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
Comment
Question by:anushahanna
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
Comment Utility
Insert statements by themselves do not benefit from bulk logged. Gotta use bulk insert.
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now