Isolating Snapshots
When you enable snapshots and create a transaction in your SQL Server Database, a transaction is created (with a unique sequence number before your intended transaction) in tempdb. Your transaction then relies on all of the rows that have a lower sequence number than the rows in tempdb which ensures that your transaction is run against your database as it appeared at the time the query was performed. This prevents rows that were created after a transaction begins from being utilized by current transactions.
For more information about snapshot isolation as well as instructions to enable it, refer to the Snapshot Isolation in SQL Server topic in the Microsoft documentation library.
Last Published Thursday, October 3, 2024