Post reply

Error converting data type varchar to float

  • January 25, 2020 at 9:59 am

    #3720366

    Jeff Moden wrote:

    Ah... one more thing... REPLACE can make sucking sounds for performance even if the default collation is used.  It's performance can usually be increased by quite a bit when you're looking for non-alpha characters to replace by using a binary collation in the formula, as in the following (obviously, not totally tested because I don't have your data table)...

    I find that the lung puncture like sucking sound is normally in direct relation to (length + number of operations), not concerned on VARCHAR(7)

    😎

     

  • January 25, 2020 at 9:58 pm

    #3720405

    It still makes a difference even on something small when you're working with millions of rows.

    --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 2 posts - 16 through 16 (of 16 total)

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