Home Forums SQL Server 2008 SQL Server 2008 - General What happens when there is update to rows (in terms of database internals) RE: What happens when there is update to rows (in terms of database internals)

  • April 20, 2013 at 4:55 pm

    #1608510

    Close enough.

    Dird (4/20/2013)

    the redo & undo being written to the TLog by lazywriter

    Lazy writer does not do writes to the transaction log.

    and the undo record is logged in the tempdp.

    Only if the DB is running in one of the row version isolation levels or there's an update trigger (and if there is, it's the previous version, not the undo info)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass