Tag: NOLOCK

When running a query against a database that is highly available and records can be accessed at any time, I typically use the “with (NoLock)” hint in my SQL statements. This ensures that if I’m accessing the same record as another user that we do not cause a deadlock. NoLock also runs slightly faster because…