• Alan.B - Monday, November 20, 2017 7:11 PM

    Jeff Moden - Monday, November 20, 2017 7:04 PM

    Jason A. Long - Monday, November 20, 2017 5:13 PM

    Basically a DTA that doesn't suck...

    Heh... THAT, my friend, has yet to be seen both on the regressive plans and the index recommendations. 😉

    ... and the genius index naming convention :hehe:

    BWAAAA-HAAAAA!!!!!  I was just thinking that and also thinking "thank goodness it wasn't XML". 😉

    I'm also thinking they HAD to name the way they did or their recommendations for keys and includes would very quickly outstrip the 128 character object limit if actual column names were used... especially with how some people name columns.  At least they used something logical that could actually be split and rendered to come up with the column names.

    Of course, Index001, Index002, etc, might not have been the end of the world.

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