What is nolock hint in sql server 2008
John Peterson
when we use with (nolock) with any query, sqlserver does not issue shared locks or exclusive lock. dirty read is possible with nolock.