Home Forums SQLServerCentral.com Editorials The Number that shouldn't be a number RE: The Number that shouldn't be a number

  • February 1, 2015 at 10:28 am

    #1774640

    jarick 15608 (2/1/2015)

    How about storing all of the data in XML in a compressed binary string and using and using am image datatype to store it in. To read the data, they had to use a custom function to un-compress the XML string and then parse through that to look up data.

    This is one that it took 14 hours to pull reporting data from.

    WOW! Seriously? Someone actually did that and someone let them? :sick: Heh... and let me guess... it was a scalar or multi-statement function on top of all that. :hehe:

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