Post reply

(nolock) or with (nolock) that''s the question!

  • February 14, 2007 at 1:12 pm

    #175915

    I have been a DBA for a while and have always used just (nolock) after a table name.

    Now I'm seeing even in BOL that it should be 'with (nolock)'. Is there any performance gain between the two?

    Does one act differently than another?

    THanks in advance

    Susan

     

  • February 14, 2007 at 1:20 pm

    #689821

    I think its just difference in syntax from 2000 to 2005.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • February 14, 2007 at 1:22 pm

    #689823

    So going forward it's politically correct to use 'with (nolock)'?

  • February 14, 2007 at 3:18 pm

    #689850

    AFAIK, you dont need to use WITH for NOLOCK. If you have index hints then you have to use the WITH keyword. but for Locking hints you dont need to use WITH.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply