Managing TempDB in SQL Server: TempDB Basics (Version Store: Why do we need it?)

Managing TempDB in SQL Server: TempDB Basics (Version Store: Why do we need it?)http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/22/managing-tempdb-in-sql-server-tempdb-basics-verison-store.aspxVersion store is a new entity in SQL Server 2005. It is used to store versions of data and index rows. A row version typically is an older copy of the data or an index row and is created to support existing (triggers) and new features (snapshot basedenCommunityServer 2.1 SP1 (Build: 61025.2) SQL Server Storage Engine Managing TempDB in SQL Server TempDB | Paid Surveyshttp://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/22/managing-tempdb-in-sql-server-tempdb-basics-verison-store.aspx#9684557Tue, 02 Jun 2009 11:11:02 GMT91d46819-8472-40ad-a661-2c78acb4018c:9684557 SQL Server Storage Engine Managing TempDB in SQL Server TempDB | Paid Surveys<p>PingBack from <a rel="nofollow" target="_new" href="http://paidsurveyshub.info/story.php?id=73146">http://paidsurveyshub.info/story.php?id=73146</a></p>