Finding and Triaging Scalar UDFs Across Your Environment
You've learned why Scalar UDFs are slow and how to remove them. The last question: where do you even start? Here's how I triage them across a whole environment.
Parallelism
3 posts
Fixing Scalar UDFs: SCHEMABINDING, Inlining and ITVF Rewrites
Nuke them from orbit, or inline them. The practical ways to neutralize Scalar UDF performance pain, from a free SCHEMABINDING win to a full ITVF rewrite.
How Scalar Functions Prevent Parallelism
Consultants hate me for this one weird trick. Because I'll be uncovering all the mess Scalar functions can cause in a series of articles.