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.
3 Comments. Leave new
[…] mind undocumented patches – Microsoft stopped documenting the contents of their patches, then got even worse, and as of 2021, they’re even shipping updates with new undocumented features. That makes me […]
[…] SQL Server 2019 Cumulative Update 11 added a few new rows in sys.messages that indicate Microsoft’s working on this, […]
CU 12 Released
is it any better?