From the course: SQL Server Performance for Developers
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
RCSI: Why it's good - SQL Server Tutorial
From the course: SQL Server Performance for Developers
RCSI: Why it's good
- [Narrator] As you've learned, read committed is the default isolation level in SQL Server. So, what do we talk about when we talk about read committed snapshot isolation? This is something you can set at the database level. It functions similarly to read committed in that if you need to read data that is currently locked by another session's uncommitted changes, it will block that read. However, read committed snapshot isolation, as it's known, or RCSI, as we like to call it in SQL Server parlance, aims to minimize this blocking effect by using row versioning. Essentially, before a row is locked in preparation for changes, that means an update statement that might be run to a given row, that row is then placed in a version store, so, if you've ever worked with Oracle, this version store is very similar to the undue table space in Oracle, except in SQL Server, we store our row versions in temp DB. When a select query wants to read a row that's being updated or is in the process of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.