Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Robert Marda Performance Adding Hints RE: Performance Adding Hints

  • June 4, 2008 at 5:33 pm

    #824595

    Kevin (6/4/2008)

    The question I have is WHat if you have some tables that have a With(NOLOCK) hint on them that are joined to tables that do not have the NOLOCK hint on them

    i.e. Select *

    from title WITH(NOLOCK)

    inner join authors on authors.aid = t.aid

    This is starting to happen now when some developers are editing existing code - and leaving out the NOLOCK -

    We are starting to see some blocking going on and have not yet determined if this is the cause or not.

    Thanks.

    Teach the new developers your standards... if you can't enforce the standards with code reviews before the code makes it to production, then you have no standards... just new blocking sources 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)