SQL Server Performance

Using NO LOCK

Discussion in 'General Developer Questions' started by georgedamien, Jul 31, 2006.

  1. georgedamien New Member

    Hi,

    In Query Analyzer, if I use NO LOCK in a select statement will it ensure that no locks will be used when the query executes?
  2. Adriaan New Member

    If you add WITH (NOLOCK) after a table name in the FROM clause, then no locks will be held on that table for the duration of the query. However, you may also get dirty results, as updates and deletes from other processes are being ignored.
  3. FrankKalis Moderator

  4. satya Moderator

    ... and also refer to the books online for the LOCKING hints and other related topics.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page