New answers tagged

4

You should read up on MVCC (Multi Version Concurrency Control), also known as record versioning, record shadowing and even multi generational architecture. What it means is that when a transaction reads a record, what it actually gets is a copy of the record. Then another transaction reads the record - gets another copy. Transaction 1 changes its copy of ...


4

How is it that N number of users can access the same physical data at the same time? This is done using transactions (honors ACID properties) & concurrency models. SQL server supports Optimistic concurrency as well as Pessimistic concurrency (default concurrency model) which inturn uses different isolation levels (read committed is the default ...



Top 50 recent answers are included