Justify NOT using (nolock) hint in every query
23
votes
3
answers
5412
views
Have you ever had to justify NOT using a query hint?
I am seeing
WITH (NOLOCK)
in every single query that hits a very busy server. It is to the point that the developers think it should just be on by default because they hate seeing it in their code thousands of times.
I tried to explain that it is allowing dirty reads and they will end up with bad data eventually, but they believe the performance tradeoff is well worth it. (Their database is a mess; no wonder they have performance issues.)
If you have a clear example of how to present the case against this abuse of the NOLOCK
hint, that would be appreciated.
Asked by datagod
(7141 rep)
May 12, 2011, 03:26 PM
Last activity: Feb 19, 2021, 09:18 AM
Last activity: Feb 19, 2021, 09:18 AM