Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Bulk-Logged Mode


Bulk-Logged Mode

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36385 Visits: 18761
Joe Howard (6/8/2010)
Good question, and I really appreciate the detailed explanation. I wish all the QoDs were so well explained.

What I don't appreciate is the sales pitch at the end. Point us to your or other's blog postings or web sites, but don't try to sell us on attending a for-profit session or class. It turns the whole question into an advertisement, which are hard enough to avoid already.

Joe


Joe,

Sorry you feel that way. I made the offer to Paul to get some great questions and info from him as he's been a great supporter of SQLServerCentral with great posts and information over the years. His classes aren't that well known, so this is a way to let people know they're available.

Many people do want to learn about opportunities that are out there for things like training.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Joe Howard
Joe Howard
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1617 Visits: 154
I appreciate your efforts, Steve, to encourage good questions and good explanations that help to educate, clarify and/or possibly intrigue us to check things out further. I also recognize you're part of a business to make a profit, and getting high caliber consultants to contribute for free is really a boon for you. But, there are plenty of other venues for distributing advertisements for pay-for events - e.g., blog postings, special emails to subscribers. The QoD is not one that comes quickly to mind.

Paul, I am a consultant as well, so I recognize the cost of the time involved in putting good information together. I applaud your contribution along with all of the good (free) information that you've made available to all of us in several venues. Please keep up the good work. Maybe you can arrange with Steve to send out one advertisement email for each 2 or 3 QoDs you provide. That could include links to register, etc. I'd like that better.

Joe
UMG Developer
UMG Developer
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2280 Visits: 2204
I have to say that I really appreciate the high-quality questions, and the follow-up responses that Paul provides. I have learned a lot from what he has provided.

And the small blurb about his training courses in the QotD doesn't bother me at all. The site has ads all over, but I think the information and learning available are well worth the expensive of being exposed to the ads, since the site is totally free.
Daniel Bowlin
Daniel Bowlin
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2954 Visits: 2629
Great question, thanks. I did a bit of reading to make sure my memory was correct about what was minimally logged and what was not, but then I tripped up on the log size.

As far as the self promotional blurb at the end....SSC is one of the best free technical sites in the world. The community is strong, doesn't flame new comers for basic questions, and usually doesn't get very far off topic. I keep 4 tabs open in my browser all day at work, 1 is SSC and the other 3 are work sites. Although I think SSC would be substantially diminished if it were to go much more advertising supported, I think it is fair to allow the best contributors an occasional text paragraph with a link. I recognize the names of many of the regular contributors to this site; I recognize them as knowledgeable in the field and I would appreciate the opportunity to see one of them speak or teach if it were near by me. So, my vote would be to allow such basic self promotion as part of featured components of the site such as QOTD, Articles, and Editorials.
Oleg Netchaev
Oleg Netchaev
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1693 Visits: 1809
Great question, it taught me something new today, thank you Paul! I got it wrong because I believed that log backups will be smaller (did not even notice a lot word there), so I picked Answers B and C option. The following statement in this BOL page helped me to answer incorrectly:

The bulk-logged recovery model... provides the best performance and least log space usage.

On the same page though it also states that log backups under bulk-logged model can be

larger and take longer to complete than under the full recovery model

, so option C was clearly not an option Sad

As far as the sales pitch is concerned, I actually like it, because though SSC and Ask.SSC are not the only Internet sites I visit, they are the only sites which I go to every day, and therefore, I would never even know about existence of the class mentioned in the explanation. Since it is in London, I cannot go of course, but if you had it anywhere near big ol' Texas I would be one of the first ones to register.

Oleg
WayneS
WayneS
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6271 Visits: 10404
wrt the log file... I think the give-away here was the wording it "will be a lot smaller".

This implies that it is 100% certain to be so - and in a multiple choice quiz, those are almost always the first to get thrown out.

Have to admit though... I answered with trepidation. After all, a QotD from Paul... well, you never know exactly what you don't know until you handle one of his questions.

(Hey Paul... when's Kimberly going to write some? :-D)

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

SanjayAttray
SanjayAttray
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3953 Visits: 1619
Good and easy but most imp. DBA interview question. In most interviews I was always asked pro's and con's of Simple, full and Bulk-logged recovery mode databases.

SQL DBA.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36385 Visits: 18761
Joe, thanks for the response, but I think you'd find many more people upset over a separate email than a short note.

We'll likely continue to do this, but I do try to make sure I minimize it to a few places, and not too often.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
KevinC.
KevinC.
Right there with Babe
Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)

Group: General Forum Members
Points: 771 Visits: 504
Thanks for the excellent question, Paul. I am happy to say I learned this from you previously through your blog and I was able to get it right!

Thanks again.
yogender
yogender
Old Hand
Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)

Group: General Forum Members
Points: 393 Visits: 131
good question.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search