I write about how to triage the Scalar UDFs in your environment. This is probably the final article in this series.
In this longest post in the series, I’ll show you how you can fix the problems with Scalar UDFs.
Continuing the series, we’ll examine how Scalar functions are terrible for performance.
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.
Believe it or not, there is a wrong and correct way when it comes to generating XML documents in SQL.