Can someone explain the ramifications of using with (nolock) on queries, as well as when it should be used and when it shouldn't be used?
What sorts of queries would nolock be acceptable in if you have a banking application with high transaction rates and a lot of data in particular tables? Is there a time when you should always use it and when you should never use it?