Announcing SQL Server 2019 Cumulative Update 11: This One Goes to …

Fans of Spinal Tap will be pleased to know this update goes even higher.

As has been a theme for SQL Server 2019, Microsoft is still struggling with inlining scalar functions. In this CU, your queries will get slower because scalar function inlining has been turned off in these scenarios:

• If the query invoking the UDF has Common Table Expressions (CTEs)
• If the UDF references encrypted columns
• If the UDF contains references to ‘WITH XMLNAMESPACES’

Ouch! And with most of the rest of the fixes, Microsoft didn’t even bother to document ’em. We just get one-line summaries with random capitalization, spacing, and grammar issues like this:

<sigh>

So while I don’t think there’s much data quality in Cumulative Update 11’s documentation, if you want it, it’s there. Good luck.