• phoqueme (1/27/2009)


    When giving examples, there is no need to blunder through every possible case of Table Scans before "realizing" MS SQL will only use the index scan on the column that has been indexed.

    Although this is the way a beginner would do it while playing with MS SQL, there is no need to write it in your article. This only distracts the reader. It's nice to hear a different flavour of english but in many cases the meaning of your sentences was actually incorrect.

    Heh... all that from someone with a handle like "phoqueme". Grow up.

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