Post reply

Getting the main course right

  • November 22, 2018 at 5:33 pm

    #2014367

    Ah... beware... I just had a trusted friend tell me that he's been testing TRANSLATE and that, unless you use something like binary collation, it's a dog for performance.  I can't test it myself because I don't have 2017 yet.

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

  • November 22, 2018 at 6:03 pm

    #2014368

    Jeff Moden - Thursday, November 22, 2018 5:33 PM

    Ah... beware... I just had a trusted friend tell me that he's been testing TRANSLATE and that, unless you use something like binary collation, it's a dog for performance.  I can't test it myself because I don't have 2017 yet.

    That doesn't surprise me - if you think about collations, they must be a nightmare to implement (not just for TRANSLATE, but also for equality testing, sorting, indexing, etc.).  The more I actually think about collations, the more I realize why one should never use character fields for keys if performance matters at all.

Viewing 2 posts - 16 through 16 (of 16 total)

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