29/04/2019 - In this tip we look at the SQL Server NOLOCK hint and how it impacts query results, both good and bad. That said, SQL Server 2005 fixed most of the bugs that made NOLOCK necessary. So unless you are using SQL Server 2000 or earlier, you shouldn't need it. 14/02/2018 - SQL Server table hints are a special type of explicit command that is used to override the default behavior of the SQL Server query optimizer . 06/06/2017 - Every once in a while, SQL Server database administrators find themselves . However, the NOLOCK table hint allows you to instruct the query . 30/11/2012 - The WITH (nolock) hint is an explicit command directed at a specific table or view used to set the transaction isolation level against the table or . 17/08/2012 - You have given many good links already, but I would suggest also going through this article What should be considered when NOLOCK hint is . 30/08/2017 - READUNCOMMITTED and NOLOCK cannot be specified for tables modified by insert, update, or delete operations. The SQL Server query . 29/01/2018 - Lots of people don't like NOLOCK (i.e. the read uncommitted isolation level) in SQL Server because it can return inaccurate data. I've seen . 17/01/2019 - The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a process .