GilaMonster (4/20/2013)
Lazy writer does not do writes to the transaction log.
Oh lol I meant log writer -_ I should have just said LGWR like i wanted to >_< (http://www.pasteall.org/pic/show.php?id=49671)
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)[/quote]
Ah OK yeah, my answer was very much Oracle focused so I forgot that SQL lets you see uncommited data changes.
Edit: Do you know what process generates the change vectors? 😮
Dird