From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Transaction isolation strategy

Transaction isolation strategy - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Transaction isolation strategy

“

- [Instructor] Transaction isolation is what pairs concurrency effects with transaction locks. The isolation level defines what type of concurrency side effects are allowable during the execution of the transaction so as to minimize the impact on other users while still providing the appropriate level of data integrity protection. With transaction isolation, you are literally defining how a transaction will remain separate from the effects of other transactions. You can control whether locks are taken when data is read, how long those locks are held before releasing and whether reads on rows that have been modified by another transaction retrieves the committed version before the modification, reads uncommitted data, or blocks the read until the lock is removed and the final modifications are committed. The isolation levels are set by issuing the set transaction isolation level command followed by one of the following options: from the lowest level of isolation to the highest, they…

Contents