title: What is "with (nolock)" in SQL Server?
body: <p>Can someone explain the implications of using <code>with (nolock)</code> on queries, when you should/shouldn't use it?</p>
  
  <p>For example, if you have a banking application with high transaction rates and a lot of data in certain tables, in what types of queries would nolock be okay?  Are there cases when you should always use it/never use it?</p>