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...
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
INSERT INTO #BrowseList1(OrderId,OrderGroupId,InterfaceId)
SELECT OrderId,OrderGroupId,InterfaceId FROM AB_TF()
WHERE ( HolderId = N'1' ) ORDER BY OrderGroupId ASC;
--Slow running query
FROM CD_TF() AS o
#BrowseList1 AS browser ON (o.OrderId = browser.OrderId AND o.OrderGroupId = browser.OrderGroupId AND o.InterfaceId = browser.InterfaceId)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.