Hi Wayne,
Nice article!
I would be interested to know if there is a linear relation between the performance gain using NOLOCK and the number of joins
performed in the query. I suspect that you might see that the effect increases with the number of joins. Also , the effect
is probably greatest in a busy database where there might be a problem with lock waits - but this would be difficult to test in a
controlled environment.
Dennis