I would suggest (if NOLOCK is a requirement) to use NOLOCK, not WITH (NOLOCK).

NOLOCK without brackets is not a hint, but a table name alias.

So, the query would be using appropriate transaction isolation and no dirty reads would be involved.

:hehe: