• 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