STRING and FIND SQL Functions

  • Comments posted to this topic are about the item STRING and FIND SQL Functions

  • I appreciate anyone that takes the time to post solutions for common problems.

    With that and considering that these functions appear to be scalar functions with While loops, and the possible hidden performance problems of returning NVARCHAR output to something that passed in VARCHAR inputs, what have you done insofar as performance testing?

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

  • Sigh... and so it goes. :discuss:

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

  • Hi Jeff,
    This was part of my college degree final project and the focus was on adding functionality over the string search with a new FIND function and creating an easy, standard, intuitive and readable way of operating transformations over a string with a new STRING function.
    Both needs that I think urge on SQL Server and come in the way Microsoft has been building on the most recent SQL Server versions.
    Therefore, the performance was not the focus but anyway analyzed for several examples in comparison with the current alternative using the string SQL system functions and the results were, as expected, poor, mostly when executing the STRING transformations with multiple operator.
    Here is the complete report on the assignment.

    Best regards
    Pedro Costa

  • Thanks, Pedro.  I'll take a look.

    --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 5 posts - 1 through 4 (of 4 total)

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