SQL Server: What is SNAPSHOT Isolation Level?

The SNAPSHOT Isolation Level constructed based on MVCC – Multiversion Concurrency Control Architecture. This is also one of my favourite Isolation levels because I like the concept of row versioning. Before further discussion on SNAPSHOT, You guys should know about, What is MVCC? Other RDBMS like: MySQL InnoDB Engine and PostgreSQL is based on MVCC … Continue reading SQL Server: What is SNAPSHOT Isolation Level?