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

  • April 7, 2011 at 2:15 pm

    #1308821

    CirquedeSQLeil (4/7/2011)

    In an effort to clarify - a request has been sent to Paul Randal on the subject.

    FYI, Paul has responded (via Twitter):

    "Tell them I said all vstore activity is nonlogged, but updates that cause vstore activity are fully logged of course"

    He also says that a better choice for the question would have been: "changes to the version store in tempdb", because DML that generates version has to change user DB and version store.

    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