• Reason I want to use NoLock is because queries are returning slowly. Instructions say that is what it is good for.

    This is on a reporting database, not a transactional database, though there are datadumps on a daily basis, pulling fresh data in. but only at prescribed times, not all day long.