The following statement turns snapshot isolation on:
ALTER DATABASE sqlserverplanet SET ALLOW_SNAPSHOT_ISOLATION ON GO ALTER DATABASE sqlserverplanet SET READ_COMMITTED_SNAPSHOT ON
Once snapshot isolation is on, rows that have been modified will fill the version store. To find the amount of space the version store is using, execute:
SELECT version_store_in_kb = version_store_reserved_page_count*8192/1024 FROM sys.dm_db_file_space_usage
Popular search terms:
