SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

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

2 years ago
Brent Ozar
SQL Server 2019, Updates
3 Comments

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:

That's some data quality alright

<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.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
New SQL Server 2019 CU9, 2016 SP2 CU 16
Next Post
Announcing SQL Server 2017 Cumulative Update 25: The Silver Anniversary

3 Comments. Leave new

  • Which Version of SQL Server Should You Use? - Brent Ozar Unlimited®
    June 11, 2021 1:20 am

    […] 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 […]

    Reply
  • Adding Managed Instances to SQL Server Distributed Availability Groups - Brent Ozar Unlimited®
    June 22, 2021 1:17 am

    […] SQL Server 2019 Cumulative Update 11 added a few new rows in sys.messages that indicate Microsoft’s working on this, […]

    Reply
  • Michael K
    August 23, 2021 9:31 am

    CU 12 Released
    is it any better?

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021
  • Announcing 2016 Service Pack 3 and 2017 CU26 September 15, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy