Post reply

NOLOCK

  • September 28, 2007 at 1:59 pm

    #175247

    WHat is nolock?

    What is hit?

  • September 28, 2007 at 2:13 pm

    #737278

    Look up NOLOCK in BOL. NOLOCK tells the query optimizer to not lock rows when performing a SELECT. The hit is that you are allowing for dirty reads. If you don't care about dirty reads, NOLOCK may work well for some of your SELECTs.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • September 28, 2007 at 2:26 pm

    #737281

    Thank u

    what is hint ?

  • September 28, 2007 at 8:03 pm

    #737300

    Open Query Analyser (QA), hit f1, type hint, enter. Read. Thank you for doing that before posting a question here.

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

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