Category Archives: SQL

Alternative to WITH (NOLOCK) in your SQL

Querying a table with the table hint NOLOCK allows a ‘dirty’ read to take place without applying a lock on the table. The advantages of this are performance over reliability because there may be uncommitted transactions or updates in progress, … Continue reading

Posted in SQL | Leave a comment