Why the Query Hint NOLOCK is a bad idea
A few weeks ago I have presented my Performance Tuning Workshop in Utrecht/Netherlands. On the 3rd day – the most intensive one, where I cover Locking, Blocking, Deadlocking, Latching, Spinlocking – we have also talked about the NOLOCK query hint. Some people always refer to the NOLOCK query hint as the Turbo Booster in SQL …
