SQL Server 2017 articles, fixes and updates - letter I

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2017 starts with letter I that have been released. The list is daily updated.

• 5018050 Improvement: Add new Azure SQL Database service tier options to the Stretch Database feature Q5018050 KB5018050 June 19, 2024
• 4090004 Improvement: Configure SESSION_TIMEOUT value for a Distributed Availability Group replica in SQL Server 2016 and 2017 Q4090004 KB4090004 July 20, 2023
• 5014047 Improvement: Match the lock escalation policy for the change tracking table to that of the base table Q5014047 KB5014047 July 13, 2022
• 4339875 Improvements for Always On Availability Groups on a Pacemaker cluster in SQL Server Q4339875 KB4339875 June 21, 2022
• 4538205 Improvement: Download new CAB files that have fixes for R/Python runtime features Q4538205 KB4538205 June 2, 2022
• 4490144 Improvement: New XEvent sqlserver.security_authentication_perf_interrogate_login is added in SQL Server 2017 Q4490144 KB4490144 June 2, 2022
• 4530907 Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 Q4530907 KB4530907 October 5, 2021
• 5004766 Improvement: Failover Cluster DNN in SQL Server 2017 Q5004766 KB5004766 September 29, 2021
• 4578579 Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 Q4578579 KB4578579 September 16, 2021
• 4541132 Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2016, 2017 and 2019 Q4541132 KB4541132 September 16, 2021
• 4500511 Improvement: Improve CDC supportability and usability with In-Memory Databases Q4500511 KB4500511 September 15, 2021
• 4480630 Improvement: Enhancement adds sql_statement_post_compile extended event in SQL Server 2017 and 2016 Q4480630 KB4480630 September 15, 2021
• 5004767 Improvement: Availability Group DNN listener in SQL Server 2017 Q5004767 KB5004767 July 12, 2021
• 5001260 Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server Q5001260 KB5001260 May 11, 2021
• 4571296 Improvement: Option to forcefully turn QDS off by specifying the additional option in ALTER DB command Q4571296 KB4571296 February 24, 2021
• 4089718 Improvement: Performance issue when upgrading MDS from SQL Server 2012 to 2016 Q4089718 KB4089718 February 23, 2021
• 4565944 Improvement: A manual method to set maximum group commit time in SQL Server 2017 and 2019 Q4565944 KB4565944 February 11, 2021
• 4488943 Improvement: New trace flag 8089 is available for faster filtered dump in SQL Server 2017 Q4488943 KB4488943 February 4, 2021
• 4342424 Improvement: Update to support QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n in USE HINT option in SQL Server 2017 Q4342424 KB4342424 January 26, 2021
• 4131496 Improvement: Enable "forced flush" mechanism in SQL Server 2017 on Linux Q4131496 KB4131496 January 26, 2021
• 4078301 Improvement: Increase the parallelism of external queries that can be executed by the modern Get Data experience in SSAS 2017 Tabular model Q4078301 KB4078301 January 26, 2021
• 4078095 Improvement: Improves the performance of SQL Server 2017 on smaller systems Q4078095 KB4078095 January 26, 2021
• 4054842 Improvement: General improvements to the change tracking cleanup process in SQL Server 2016 and 2017 Q4054842 KB4054842 January 26, 2021
• 4053439 Improvement: Move master database and error log file to another location in SQL Server 2017 on Linux Q4053439 KB4053439 January 26, 2021
• 4041814 Improve tempdb spill diagnostics in DMV and Extended Events in SQL Server 2017 and SQL Server 2016 SP2 Q4041814 KB4041814 January 26, 2021
• 2634571 Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option Q2634571 KB2634571 January 26, 2021
• 4344904 Improvement enables CREATE AVAILABILITY GROUP and ALTER AVAILABILITY GROUP DDLs to set the SESSION_TIMEOUT for a configuration-only replica in SQL Server Q4344904 KB4344904 January 14, 2021
• 4341264 Improvement: SQL Server Agent jobs can start without waiting for all databases to recover in SQL Server 2017 on Linux Q4341264 KB4341264 January 14, 2021
• 4339090 Improvement to reduce the fail-over duration for an availability group in SQL Server on Linux Q4339090 KB4339090 January 14, 2021
• 4089276 Improves the query performance when an optimized bitmap filter is applied to a query plan in SQL Server 2016 and 2017 Q4089276 KB4089276 January 14, 2021
• 4488257 Inconsistent results in MKL computations because of a missing environment variable in Microsoft R Server or Machine Learning Server Q4488257 KB4488257 October 24, 2020
• 4532751 Improvement: Snapshot replication and transactional replication are enabled on Linux in SQL Server 2017 Q4532751 KB4532751 October 23, 2020
• 4530302 Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 Q4530302 KB4530302 October 23, 2020
• 4512820 Improvement: Microsoft Distributed Transaction Coordinator is enabled on Linux in SQL Server 2017 Q4512820 KB4512820 October 23, 2020
• 4490145 Improvement: New mssql-conf option network.enablekdcfromkrb5 is added in SQL Server 2017 Q4490145 KB4490145 October 23, 2020
• 4490141 Improvement: DMV sys.dm_hadr_cluster reports cloud witness quorum type "4" and quorum_type_desc "UNKNOWN_QUORUM" in SQL Server 2016 and 2017 Q4490141 KB4490141 October 23, 2020
• 4490134 Improvement: Add a new extended event query_post_execution_plan_profile in SQL Server 2017 Q4490134 KB4490134 October 23, 2020
• 4480651 Improvement: Merge operation will consider the number of deleted rows in the rowgroup in SQL Server 2016 and 2017 Q4480651 KB4480651 October 23, 2020
• 4480634 Improvement: IsAvailableInMDX feature can disable processing for specific columns in TREATAS function DAX query in SQL Server 2017 Q4480634 KB4480634 October 23, 2020
• 4468101 Improvement: Optional replacement for "String or binary data would be truncated" message with extended information in SQL Server 2016 and 2017 Q4468101 KB4468101 October 23, 2020
• 4466491 Improvement: You can set the minimum interval value to less than 10 seconds for running SSIS packages in parallel in SQL Server 2017 Q4466491 KB4466491 October 23, 2020
• 3210239 Interoperability of Columnstore indexes with large page memory model in SQL Server Q3210239 KB3210239 December 16, 2019
• 4099335 Improvement in finding actual errors when you execute the Test-SqlAvailabilityGroup cmdlet in SQL Server Q4099335 KB4099335 January 23, 2019
• 3092936 Increased CPU usage when you access a SQL Server FileTable share from Windows Explorer Q3092936 KB3092936 October 9, 2017