SQL SERVER 2019 CU 12 - Any issues?

Michael MacGregor 86 Reputation points
2021-09-16T20:58:28.657+00:00

We are looking at updating to CU 12 for our SQL Server 2019 installations. Has anyone encountered any major issues with this update? I heard that CU 11 had not fixed the issues with inline scalar functions, is that still the case for CU 12?

Any other information/experience you think might be useful will be appreciated.

Regards,

Michael MacGregor
Database Architect

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,068 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Erland Sommarskog 103.5K Reputation points MVP
    2021-09-16T21:32:31.903+00:00

    I have not heard of anything as I can recall.

    What issues about scalar functions do you have in mind? I mean that they are not generally broken, but there may specific bugs.

    0 comments No comments

  2. Michael MacGregor 86 Reputation points
    2021-09-17T01:26:53.783+00:00

    Hi Erland,

    According to Brent Ozar, MS is still struggling with the performance of inline scalar functions and CU 11 scalar function inlining is turned off in the following circumstances:

    If the query invoking the UDF uses CTEs.
    If the UDF references encrypted columns.
    If the UDF contains references to WITH XMLNAMESPACES.

    Regards,

    Mike


  3. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2021-09-17T02:28:16.71+00:00

    Hi Mike,

    I did not find any MS blog or document that announced the issue is fixed in CU12. I check this in MS blog KB5004524 - Cumulative Update 12 for SQL Server 2019.

    Quote from the MS blog KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2019.

    >This cumulative update also blocks inlining in the following scenarios:

    >• If the UDF references encrypted columns (added in Microsoft SQL Server 2019 CU11)

    >• If the UDF contains references to 'WITH XMLNAMESPACES' (added in Microsoft SQL Server 2019 CU11)

    >• If the query invoking the UDF has Common Table Expressions (CTEs) (added in Microsoft SQL Server 2019 CU11)

    This blog also did not mention that CU12 fix the issues.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments No comments

  4. Michael MacGregor 86 Reputation points
    2021-09-17T02:39:32.653+00:00

    Hi Cathy,

    Thank you.

    Though I'm still curious to know if anyone has experienced any other issues with CU 12.

    Regards,

    Mike

    0 comments No comments