NOLOCK is not a turbo button
All to often when talking to developers they put the WITH (NOLOCK) table hint in place to speed up queries without understanding what the table hint does. I’ve even run across companies that have policies in place that every select statement must have the WITH (NOLOCK) table hint. The WITH (NOLOCK) table hint isn’t a […]