Using WITH (NOLOCK)

Pros for NOLOCK:

  • Better memory usage
  • Prevention of deadlocks

Cons:

  • Might read dirty data

I guess it depends on use cases. In our case I would argue in favor of overall server health instead of accidentally reading dirty data. Our users know that Epicor data is not to be trusted 100% anyhow. But YMMV I guess.