• WayneS (4/7/2011)


    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.

    Most Excellent

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events