What is “with (nolock)” in SQL Server?

by

WITH (NOLOCK) is the equivalent of using READ UNCOMMITED as a transaction isolation level. So, you stand the risk of reading an uncommitted row that is subsequently rolled back, i.e. data that never made it into the database. So, while it can prevent reads being deadlocked by other operations, it comes with a risk. In a banking application with high transaction rates, it’s probably not going to be the right solution to whatever problem you’re trying to solve with it IMHO.

More Related Contents:

  1. Using NOLOCK Hint in EF4?
  2. What is the best way to create and populate a numbers table?
  3. How do I generate a random number for each row in a T-SQL select?
  4. Auto increment primary key in SQL Server Management Studio 2012
  5. What is the use of the square brackets [] in sql statements?
  6. Construct date from year and week number in MSSQL
  7. Reset AutoIncrement in SQL Server after Delete
  8. SQL Server – find nth occurrence in a string
  9. XML Server XML performance optimization
  10. SQL Server: Attach incorrect version 661
  11. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  12. How to do version control for SQL Server database?
  13. Get dates from a week number in T-SQL
  14. What are named pipes?
  15. How to check if a database exists in SQL Server?
  16. BULK INSERT with identity (auto-increment) column
  17. How to update primary key
  18. determining the character set of a table / database?
  19. How to split string and insert values into table in SQL Server
  20. Making an Entity Framework Model span multiple databases
  21. SQL Server 2008 Row Insert and Update timestamps
  22. Full text search does not work if stop word is included even though stop word list is empty
  23. Should I index a bit field in SQL Server?
  24. Setting up maven dependency for SQL Server
  25. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  26. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  27. Escaping single quote in SQL Server
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment