Post reply

The Weekly News for Oct 6, 2008 (Database Weekly)

  • October 4, 2008 at 6:03 am

    #126630

    Comments posted to this topic are about the item The Weekly News for Oct 6, 2008 (Database Weekly)

  • October 5, 2008 at 8:35 am

    #880920

    Heh... what a teaser you are. You just know that I'm going to challenge Phil's findings, don't ya? 🙂

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

  • October 6, 2008 at 8:32 am

    #881113

    Of course! Likely you'll find a faster way, but hey, that's why we love (and quote) you!

  • October 6, 2008 at 9:10 pm

    #881412

    Thought I'd give a little feedback here... Phil reran his tests on his machine several times... same result... the While loop on a super string beat the tar out of the Tally table... Let me emphasize... ON HIS MACHINE! I've tried it on several machines, now, and I find just the reverse to be true. The Tally table beats the RBAR While Loop quite handily.

    What I think everyone should get out of this is what I have said frequently in the past... Phil reemphasized the same thing... TRUST NO ONE WHEN IT COMES TO CODE... always do a test. Heh... even code that follows the ANSI Standards to a "T" could be affected according to the amount of memory available or if parallelism occurs, etc, etc. It's terrible to think that something like SQL Server 2000 or 2005 would actually be installation dependent, but, like anything else, in fact, is.

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

  • October 6, 2008 at 9:12 pm

    #881413

    Oh... I almost forgot... I ran Phil's tests without modifying his code. I was so engaged in why he was getting his "reverse" findings, that I actually forgot to try to improve on the code. It's not a simple split... it treats certain position-dependent characters as white space. I guess my next task will be to try to figure out a faster way... 😛

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

  • October 7, 2008 at 12:12 pm

    #881875

    And write an article! :hehe:

  • October 7, 2008 at 8:01 pm

    #882077

    :P;)

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply