when we use with (nolock) with any query, sqlserver does not issue shared locks or exclusive lock. dirty read is possible with nolock.