The unwanted Side Effects of enabling Read Committed Snapshot Isolation

A lot of developers are approaching me very often, and tell me that they are using the NOLOCK query hint to get rid of blocking situations in SQL Server. Unfortunately the NOLOCK query hint is not really a good solution when you hit blocking situations, because SQL Server can return you uncommitted data. Therefore I …

The unwanted Side Effects of enabling Read Committed Snapshot Isolation + read more