In this post, I am going to share an important note about the READ COMMITTED isolation level and how it works with the READ_COMMITTED_SNAPSHOT option of SQL Server. The READ COMMITTED is the default isolation level of SQL Server, and it prevents the dirty reads. Your SELECT statements always returns committed data. It issues shared … Continue reading SQL Server: READ COMMITTED Isolation Level with the READ_COMMITTED_SNAPSHOT option