Bits of .NET

Readers block writers, writers block readers → chaos.

✔ The Fix

Enable snapshot isolation:

ALTER DATABASE MyDB SET READ_COMMITTED_SNAPSHOT ON;

💡 Why

Reads no longer block updates → faster API.