Press "Enter" to skip to content

NOLOCK, No Way

Erik Darling says yes to locks…kinda:

That warning often comes with a lot of questions about how to fix blocking problems so you can get rid of those hints.

After all, if you get rid of them, your SQL Server queries will (most likely) go back to using the READ COMMITTED isolation level and we all know that read committed is a garbage isolation level, anyway.

Sadly, a quick regex through your code base isn’t sufficient…