Snapshot Isolation Level

1
Snapshot Isolation Level
2
ORACLE-like Reads

• Consistent versions of data are kept in tempdb
• Enables repeatable reads without blocking other
  users

tempdb
3
Properties
Database property
ALTER DATABASE AdventureWorks SET
ALLOW_SNAPSHOT_ISOLATION ON
Connection property
SET TRANSACTION ISOLATION LEVEL SNAPSHOT