2 thoughts on “A Trick For Working Around Scalar UDF Performance Issues”
Great post Erik! We use this trick, often it’s really effective! Sometimes it also runs loads faster because when we do this we also remove the ORDER BY when we do the SELECT INTO.
Great post Erik! We use this trick, often it’s really effective! Sometimes it also runs loads faster because when we do this we also remove the ORDER BY when we do the SELECT INTO.
This is exactly the same trick I came up with for my developers two weeks ago. It does really help!