Join Joey D'Antoni for an in-depth discussion in this video RCSI: Why it's good, part of SQL Server Performance for Developers.
- [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 being updated,…it can use that record from temp DB.…
- Query execution
- How to read an execution plan
- What not to do with SQL Server
- Why cursors are bad
- Why scalar UDFs are expensive
- Datatypes and design
- What is a columnstore index?
- Transaction isolation
Skill Level Intermediate
1. Query Execution
2. What Not to Do with SQL Server
3. Datatypes and Design
4. Temporary Objects
7. Isolation Levels
Next steps2m 15s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.