Home Forums SQL Server 2012 SQL Server 2012 - T-SQL nolock RE: nolock

  • May 16, 2013 at 12:58 pm

    #1615970

    gchappell (5/16/2013)

    Has nolock been depricated in SQL Server 2012, or does the optimizer ignore the no lock and still run?

    nolock is always ignored for insert/update delete statements, as honoring that request could potentially violate the ACID principals ;

    You can still use it for SELECT statements in SQL2012 (even though it can result in bad data, see the post above)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!