STRING and FIND SQL Functions

Question

STRING and FIND SQL Functions

pedro.costa

SSC Journeyman

Points: 82
More actions
July 9, 2018 at 1:54 pm

#366050

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

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 1

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)

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 2

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)

pedro.costa SSC Journeyman Points: 82 More actions · Answer 3

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

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 4

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)