Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Logged Operations RE: Logged Operations

  • April 7, 2011 at 10:00 am

    #1308646

    SanDroid (4/7/2011)

    You have references to validate the incorrect answers, but not to the correct one!?!?! :sick:

    Looks like 90% if the people that tried to answer this question did not understand it either. :crazy:

    I learned nothing from this question.

    We use row versioning and Full Recovery Model on our SQL 2005 server and have enabled a level of auditing so the changes to our version comuns are logged. Do you mean with defaults enabled? Is there a certain area of this system that is not logged that would have benifit?

    Perhapse you can explain the question and provide refference material for your only correct answer?

    :Whistling:

    I did post a link to a blog by the Microsoft SQL Server Storage Engine team in which they state that the version store is not logged. And as Ignacio A. Salom Rangel points out, it is also covered in Paul Randal's (who was on the SQL Storage Engine team for 9 years) blog on the TRUNCATE TABLE being logged (but somehow, I never saw that before - thanks for pointing that out.)

    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2