data-konzept

'In this tip we compare Serializable and Snapshot transaction isolation levels. Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms - which are also called phenomena in a RDBMS. Moreover, none of the other isolation levels (Read Uncommitted, Read Committed and Repeatable Read) prevent the mentioned phenomena.'...

https://www.mssqltips.com/sqlservertip/4120/comparison-of-sql-server-serializable-and-snapshot-isolation-levels/