title: Should I still use With(NoLock) in SQL Server queries?
body: <p>I'm trying to write some queries to fetch data from database. I used to use With(NoLock) to prevent SQL Server from placing shared locks on database. And recently a friend of mine told me that the default behavior now is that it doesn't put any lock on reading data.</p>
  
  <p>However, I can't find a clean explanation for this.
  Should I still use With(NoLock) in SQL Server?</p>