Performance issue on a udf - Better way to rewrite?

Question

Performance issue on a udf - Better way to rewrite?

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

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Jeff Moden (1/6/2010)
Lynn Pettis (1/6/2010)
To continue, I did write a blog about it Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
Nice... I'm curious... why blog these instead of submitting them as articles? Articles don't have to be long to be effective. This would have been a perfect article.

Don't know for sure, I guess I just needed something for my blog, and this came up while working on the data extract process.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Jeff Moden (1/6/2010)
Ya beat me to it on the POWER thing. Nicely done, Lynn.

Thanks. Seemed the simpliest way to shift the data the appropriate number of "spaces" to provide for trailing zeros.