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.
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 responses to “Using NOLOCK with SELECT statements”
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.
Hence the “90%”. : )