title: Does NOLOCK hint slow down operation?
body: <p>I have a question about the use of <code>NOLOCK</code>. </p>
  
  <p>I understand that <code>NOLOCK</code> hint is not always the best approach, but in some case it is very helpful. I am not trying to build a bad habit of using it all the time</p>
  
  <p>I just want to understand the exact behavior of it. Have this unrealistic assumtion that a process that is updating record where id = 10 <code>UPDATE table1 SET status = 2 WHERE id = 10</code> which is taking 30 seconds to update. And at the same time I execute <code>SELECT * FROM table1 WITH NOLOCK where id = 10</code></p>
  
  <p>Will my select statement read the row even though my first query had an exclusive lock on the record or will my select query wait until no locks what so ever on the record before it allows the read?</p>
  
  <p>I want to know if the use of <code>NOLOCK</code> could be causing delays or not.</p>