Using NOLOCK Hint in EF4?

by

NOLOCK = “READ UNCOMMITTED” = dirty reads

I’d assume MS knows why they chose the default isolation level as “READ COMMITTED”

NOLOCK, in fact any hint, should be used very judiciously: not by default.

Your DBA is a muppet. See this (SO): What can happen as a result of using (nolock) on every SELECT in SQL Sever?. If you happen to work at a bank, or any institution where I may have an account please let me know so I can close it.

More Related Contents:

  1. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  2. What is “with (nolock)” in SQL Server?
  3. Why use a READ UNCOMMITTED isolation level?
  4. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  5. Is it possible to use Full Text Search (FTS) with LINQ?
  6. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  7. Defining a one-to-one relationship in SQL Server
  8. Adding a query hint when calling Table-Valued Function
  9. Entity-framework code is slow when using Include() many times
  10. Making an Entity Framework Model span multiple databases
  11. How do I programmatically set the connection string for Entity-Framework Code-First?
  12. The LINQ expression could not be translated and will be evaluated locally
  13. Dynamic query with OR conditions in Entity Framework
  14. Should the order of LINQ query clauses affect Entity Framework performance?
  15. Why can’t Entity Framework see my Stored Procedure’s column information?
  16. Storing images in SQL Server?
  17. “A lambda expression with a statement body cannot be converted to an expression tree”
  18. Limitations of SQL Server Express
  19. Entity framework very slow to load for first time after every compilation
  20. SQL time difference between two dates result in hh:mm:ss
  21. Dynamic SQL (passing table name as parameter)
  22. “order by newid()” – how does it work?
  23. How to determine total number of open/active connections in ms sql server 2005
  24. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  25. ORDER BY DATE showing NULLS first then most recent dates
  26. How to split a string after specific character in SQL Server and update this value to specific column
  27. SQL Server Passthrough query as basis for a DAO recordset in Access
  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