Sometimes, you hear of something and you think „that’s just what I need!“ only to find that in the real world „things are a bit more complicated than you think“

READ_COMMITTED_SNAPSHOT

Is an example of this. At first sight I thought „why isn’t this the standard setting“ but this question-and-answer article might explain why…

via What risks are there if we enable read committed snapshot in sql-server? – Database Administrators Stack Exchange.