Concurrency Control in SQL Server

Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.

SELECT and Locking

Transaction Isolation Levels

Introduction While working with SQL databases, we ...

Comparison of SQL Server Serializable and Snapshot isolation levels

Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms. However the way in which they deal with such issues is quite different. In this article, Sergey Gigoyan explains the main differences between the two.

Phantoms and isolation

Transaction Isolation Levels

An examination into how the various transaction isolation levels affect locking (and blocking)

SQL Server Transactions and Locking – Part 2

This article looks at SQL Server locking and transaction isolation levels, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning. It also explains what type of locks data update requires.

Part 1: How to solve the transactional issues of isolation levels

Transaction Isolation levels are described in terms of which concurrency side-effects, such as dirty reads or phantom reads, are allowed.

Isolation Levels

Transaction isolation