3 ms·
> A great many developers using MS SQL Server don't even know the option exists. Yes, default behavior is so prone to locks - I learned it the hard way. Switch
by insulanian 11y ago
> A great many developers using MS SQL Server don't even know the option exists.
Yes, default behavior is so prone to locks - I learned it the hard way. Switching READ_COMMITTED_SNAPSHOT ON brought new life to our DB.