1 min readJan 27, 2020
There is also READ_COMMITED_SNAPSHOT. This isolation level will prevent SQL Server from issuing an update lock on a data page it intends to update. Instead it will make copies of the rows (row versions) and store them in tempdb.