Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Suresh Maganti Dealing with Incomplete Data - A T-SQL Puzzle 1 RE: Dealing with Incomplete Data - A T-SQL Puzzle 1

  • November 22, 2011 at 10:07 pm

    #1411935

    Suresh Kumar Maganti (11/22/2011)

    The Query cost (relative to the batch) was 17% for the one in the article. The same for the alternative version was 83%.

    The query cost relative to the batch actually doesn't mean much. It's quite easy to write queries that doe the same thing where one will be 100% of the batch and the other will be 0% and yet, when you run them, the 0% query take take several seconds where the 100% query runs so fast it almost isn't measureable.

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