Sql server nolock7/16/2023 When I inquire about this, the typical response I get is usually along the lines of “I don’t want my query to create any locks.” or “It helps my query run faster.” Well…that’s not exactly what NOLOCK is for. When working with developers, I’ve noticed that some have a tendency to put WITH (NOLOCK) on every table in a SELECT query.
0 Comments
Leave a Reply. |