Cumulative Update #11 for SQL Server 2019 RTM

Published Jun 10 2021 05:42 PM 1,999 Views
Microsoft

The 11th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:
• CU11 KB Article: https://support.microsoft.com/en-us/help/5003249
Starting with SQL Server 2017, we adopted a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server
• Microsoft® SQL Server® 2019 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=100809
• Update Center for Microsoft SQL Server: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sq...

1 Comment
Occasional Visitor

After upgrading from SQL server 2019 CU6 to CU11: below query marked with --Slow running query is slow suddenly. CD_TF() contains OUTER APPLY to another TF.

IF(OBJECT_ID('tempdb..#BrowseList1') IS NOT NULL)
DROP TABLE #BrowseList1
  CREATE TABLE #BrowseList1
  ( 
     RowNumber        dbo.ecm_RowNumber_DT IDENTITY(1,1)  NOT NULL PRIMARY KEY CLUSTERED
    ,OrderId        dbo.ecm_OrderId_DT 
    ,OrderGroupId     dbo.ecm_OrderGroupId_DT
    ,InterfaceId      dbo.ecm_InterfaceId_DT              
  );
  
  INSERT INTO #BrowseList1(OrderId,OrderGroupId,InterfaceId)
SELECT OrderId,OrderGroupId,InterfaceId FROM AB_TF()
WHERE ( HolderId = N'1' ) ORDER BY OrderGroupId ASC;

--Slow running query 
SELECT o.*
FROM CD_TF() AS o 
INNER JOIN 
#BrowseList1 AS browser ON (o.OrderId = browser.OrderId AND o.OrderGroupId = browser.OrderGroupId AND o.InterfaceId = browser.InterfaceId)  
%3CLINGO-SUB%20id%3D%22lingo-sub-2437598%22%20slang%3D%22en-US%22%3ECumulative%20Update%20%2311%20for%20SQL%20Server%202019%20RTM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437598%22%20slang%3D%22en-US%22%3E%3CP%3EThe%2011th%20cumulative%20update%20release%20for%20SQL%20Server%202019%20RTM%20is%20now%20available%20for%20download%20at%20the%20Microsoft%20Downloads%20site.%20Please%20note%20that%20registration%20is%20no%20longer%20required%20to%20download%20Cumulative%20updates.%20%3CBR%20%2F%3ETo%20learn%20more%20about%20the%20release%20or%20servicing%20model%2C%20please%20visit%3A%20%3CBR%20%2F%3E%E2%80%A2%20CU11%20KB%20Article%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F5003249%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F5003249%3C%2FA%3E%20%3CBR%20%2F%3EStarting%20with%20SQL%20Server%202017%2C%20we%20adopted%20a%20new%20modern%20servicing%20model.%20Please%20refer%20to%20our%20blog%20for%20more%20details%20on%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlreleaseservices%2Fannouncing-the-modern-servicing-model-for-sql-server%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EModern%20Servicing%20Model%3C%2FA%3E%20for%20SQL%20Server%3CBR%20%2F%3E%E2%80%A2%20Microsoft%C2%AE%20SQL%20Server%C2%AE%202019%20RTM%20Latest%20Cumulative%20Update%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D100809%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D100809%3C%2FA%3E%20%3CBR%20%2F%3E%E2%80%A2%20Update%20Center%20for%20Microsoft%20SQL%20Server%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Flatest-updates-for-microsoft-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Flatest-updates-for-microsoft-sql-server%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2437598%22%20slang%3D%22en-US%22%3E%3CP%3EThe%2011th%20cumulative%20update%20release%20for%20SQL%20Server%202019%20RTM%20is%20now%20available%20for%20download%20at%20the%20Microsoft%20Downloads%20site.%20Please%20note%20that%20registration%20is%20no%20longer%20required%20to%20download%20Cumulative%20updates.%20%3CBR%20%2F%3ETo%20learn%20more%20about%20the%20release%20or%20servicing%20model%2C%20please%20visit%3A%20%3CBR%20%2F%3E%E2%80%A2%20CU11%20KB%20Article%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F5003249%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F5003249%3C%2FA%3E%20%3CBR%20%2F%3EStarting%20with%20SQL%20Server%202017%2C%20we%20adopted%20a%20new%20modern%20servicing%20model.%20Please%20refer%20to%20our%20blog%20for%20more%20details%20on%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlreleaseservices%2Fannouncing-the-modern-servicing-model-for-sql-server%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EModern%20Servicing%20Model%3C%2FA%3E%20for%20SQL%20Server%3CBR%20%2F%3E%E2%80%A2%20Microsoft%C2%AE%20SQL%20Server%C2%AE%202019%20RTM%20Latest%20Cumulative%20Update%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D100809%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D100809%3C%2FA%3E%20%3CBR%20%2F%3E%E2%80%A2%20Update%20Center%20for%20Microsoft%20SQL%20Server%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Flatest-updates-for-microsoft-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Flatest-updates-for-microsoft-sql-server%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2437598%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLReleases%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2603582%22%20slang%3D%22en-US%22%3ERe%3A%20Cumulative%20Update%20%2311%20for%20SQL%20Server%202019%20RTM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2603582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EAfter%20upgrading%20from%20SQL%20server%202019%20CU6%20to%20CU11%3A%20below%20query%20marked%20with%20--Slow%20running%20query%20is%20slow%20suddenly.%20CD_TF()%20contains%20OUTER%20APPLY%20to%20another%20TF.%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%3EIF(OBJECT_ID(%3CSPAN%20class%3D%22hljs-string%22%3E'tempdb..%23BrowseList1'%3C%2FSPAN%3E)%20%3CSPAN%20class%3D%22hljs-keyword%22%3EIS%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3ENOT%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3ENULL%3C%2FSPAN%3E)%0A%3CSPAN%20class%3D%22hljs-keyword%22%3EDROP%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3ETABLE%3C%2FSPAN%3E%20%23BrowseList1%0A%20%20%3CSPAN%20class%3D%22hljs-keyword%22%3ECREATE%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3ETABLE%3C%2FSPAN%3E%20%23BrowseList1%0A%20%20(%20%0A%20%20%20%20%20RowNumber%20%20%20%20%20%20%20%20dbo.ecm_RowNumber_DT%20%3CSPAN%20class%3D%22hljs-keyword%22%3EIDENTITY%3C%2FSPAN%3E(%3CSPAN%20class%3D%22hljs-number%22%3E1%3C%2FSPAN%3E%2C%3CSPAN%20class%3D%22hljs-number%22%3E1%3C%2FSPAN%3E)%20%20%3CSPAN%20class%3D%22hljs-keyword%22%3ENOT%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3ENULL%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3EPRIMARY%3C%2FSPAN%3E%20KEY%20CLUSTERED%0A%20%20%20%20%2COrderId%20%20%20%20%20%20%20%20dbo.ecm_OrderId_DT%20%0A%20%20%20%20%2COrderGroupId%20%20%20%20%20dbo.ecm_OrderGroupId_DT%0A%20%20%20%20%2CInterfaceId%20%20%20%20%20%20dbo.ecm_InterfaceId_DT%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20)%3B%0A%20%20%0A%20%20%3CSPAN%20class%3D%22hljs-keyword%22%3EINSERT%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3EINTO%3C%2FSPAN%3E%20%23BrowseList1(OrderId%2COrderGroupId%2CInterfaceId)%0A%3CSPAN%20class%3D%22hljs-keyword%22%3ESELECT%3C%2FSPAN%3E%20OrderId%2COrderGroupId%2CInterfaceId%20%3CSPAN%20class%3D%22hljs-keyword%22%3EFROM%3C%2FSPAN%3E%20AB_TF()%0A%3CSPAN%20class%3D%22hljs-keyword%22%3EWHERE%3C%2FSPAN%3E%20(%20HolderId%20%3CSPAN%20class%3D%22hljs-operator%22%3E%3D%3C%2FSPAN%3E%20N%3CSPAN%20class%3D%22hljs-string%22%3E'1'%3C%2FSPAN%3E%20)%20%3CSPAN%20class%3D%22hljs-keyword%22%3EORDER%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3EBY%3C%2FSPAN%3E%20OrderGroupId%20%3CSPAN%20class%3D%22hljs-keyword%22%3EASC%3C%2FSPAN%3E%3B%0A%0A%3CSPAN%20class%3D%22hljs-comment%22%3E--Slow%20running%20query%20%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22hljs-keyword%22%3ESELECT%3C%2FSPAN%3E%20o.%3CSPAN%20class%3D%22hljs-operator%22%3E*%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22hljs-keyword%22%3EFROM%3C%2FSPAN%3E%20CD_TF()%20%3CSPAN%20class%3D%22hljs-keyword%22%3EAS%3C%2FSPAN%3E%20o%20%0A%3CSPAN%20class%3D%22hljs-keyword%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3EJOIN%3C%2FSPAN%3E%20%0A%23BrowseList1%20%3CSPAN%20class%3D%22hljs-keyword%22%3EAS%3C%2FSPAN%3E%20browser%20%3CSPAN%20class%3D%22hljs-keyword%22%3EON%3C%2FSPAN%3E%20(o.OrderId%20%3CSPAN%20class%3D%22hljs-operator%22%3E%3D%3C%2FSPAN%3E%20browser.OrderId%20%3CSPAN%20class%3D%22hljs-keyword%22%3EAND%3C%2FSPAN%3E%20o.OrderGroupId%20%3CSPAN%20class%3D%22hljs-operator%22%3E%3D%3C%2FSPAN%3E%20browser.OrderGroupId%20%3CSPAN%20class%3D%22hljs-keyword%22%3EAND%3C%2FSPAN%3E%20o.InterfaceId%20%3CSPAN%20class%3D%22hljs-operator%22%3E%3D%3C%2FSPAN%3E%20browser.InterfaceId)%20%20%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Jun 10 2021 05:51 PM
Updated by: