Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

  • March 22, 2015 at 8:05 pm

    #1785598

    I've never had a performance problem because of such switches but if I were forced at gunpoint to make a conjecture, I would unfortunately still have to say I don't know because I've never tested for that.

    I can, however, tell you that SQL Server will prevent the drop/rebuild of the synonym if someone is still using it. THAT I've tested for! It will sit and patiently wait to get exclusive use.

    --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)