• NOLOCK is a useful evil on high volume systems. In cases where you're looking at generics or structure this can be a very useful tool which can stop deadlocks. It also allows the query to proceed without slowing down the system too much. If the NOLOCK was not there the query would wait for any locked columns or rows. In effect this slows the whole system.

    In this case it is better to leave the NOLOCK in.