Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Bulk-Logged Mode Expand / Collapse
Author
Message
Posted Tuesday, June 8, 2010 11:38 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:10 PM
Points: 33,095, Visits: 15,202
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
Post #934171
Posted Tuesday, June 8, 2010 11:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:02 PM
Points: 1,513, Visits: 124
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
Post #934180
Posted Tuesday, June 8, 2010 12:13 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
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.
Post #934187
Posted Tuesday, June 8, 2010 12:24 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
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.
Post #934194
Posted Tuesday, June 8, 2010 2:53 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 12:49 PM
Points: 1,676, Visits: 1,754
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

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
Post #934265
Posted Tuesday, June 8, 2010 8:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:04 PM
Points: 6,582, Visits: 8,861
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? )


Wayne
Microsoft Certified Master: SQL Server 2008
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
Post #934357
Posted Wednesday, June 9, 2010 9:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
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.
Post #934667
Posted Wednesday, June 9, 2010 10:32 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:10 PM
Points: 33,095, Visits: 15,202
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
Post #934759
Posted Wednesday, June 9, 2010 2:42 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 7, 2010 12:55 AM
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.
Post #934966
Posted Monday, August 9, 2010 6:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 7, 2013 2:54 AM
Points: 317, Visits: 94
good question.
Post #965887
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse