http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example.aspxIn order to understand the version store, let me start with an example. I will use a database that has RCSI (read committed snapshot) and SI (Snapshot Isolation) enabled as it provides more controlled environment to manage versions. When a databaseen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example.aspx#10346417Wed, 05 Sep 2012 06:13:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:10346417Hasham Niaz<p>Just okay ...</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10346417" width="1" height="1">http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example.aspx#9258836Wed, 31 Dec 2008 22:34:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:9258836Sunil Agarwal<p>Akelly: thanks. I forgot to put the commit...I updated the blog. Thanks for your interest and feedback.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9258836" width="1" height="1">http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example.aspx#9258757Wed, 31 Dec 2008 21:12:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:9258757Checkpoint<p>SunilA has a great set of posts out on the SQL Server Storage Engine blog about managing TEMPDB. It's</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9258757" width="1" height="1">http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example.aspx#9258595Wed, 31 Dec 2008 18:45:55 GMT91d46819-8472-40ad-a661-2c78acb4018c:9258595akelly<p>Sunil,</p> <p>I believe you need a COMMIT just before the UPDATE statement to get the behavior you mentioned, otherwise the UPDATE is in an EXPLICIT tran with the INSERT.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9258595" width="1" height="1">http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example.aspx#9257952Wed, 31 Dec 2008 05:39:20 GMT91d46819-8472-40ad-a661-2c78acb4018c:9257952Managing TempDB in SQL Server: TempDB Basics (Version Store: Simple Example) | Coded Style<p>PingBack from <a rel="nofollow" target="_new" href="http://www.codedstyle.com/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example/">http://www.codedstyle.com/managing-tempdb-in-sql-server-tempdb-basics-version-store-simple-example/</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9257952" width="1" height="1">