Using NOLOCK with SELECT statements

Holy cow! Where have I been living?

You can use NOLOCK with SELECT statements to tell SQL to not lock the row/table/page/database.

2 thoughts on “Using NOLOCK with SELECT statements”

  1. NOLOCK tells sql to return data regardless of the lock status on the table or row, in other words it will return data before the commit, and could potentially return invalid data.

Leave a Reply

Your email address will not be published. Required fields are marked *