Swipe to navigate through the chapters of this book
Optimistic transaction isolation levels were introduced in SQL Server 2005 as a new way to deal with blocking problems and to address data-consistency issues. With optimistic transaction isolation levels, queries read “old” committed versions of rows while accessing the data modified by the other sessions, rather than being blocked by the incompatibility of shared (S) and exclusive (X) locks.
Please log in to get access to this content
To get access to this content you need the following product:
- Optimistic Isolation Levels
- Sequence number
- Chapter number
- Chapter 21