title: why nolock is important while querying on database
body: <p>Woking on a huge database I was extracting huge amount of data. for example my query is </p>
  
  <pre><code>select * from temp
  </code></pre>
  
  <p>it was causing errors for my application users then I realised that I was because my query was taking too long time to extract data.</p>
  
  <p>then I modified my query with </p>
  
  <pre><code>select * from temp with(nolock)
  </code></pre>
  
  <p>and then everything is smooth. somebody please explain why nolock is such important.</p>