SQL Server 2017 articles, fixes and updates - Year 2021

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

• 4552478 FIX: Distribution Agent "Parameterized values for above command" log message is missing Q4552478 KB4552478 November 24, 2021
• 5004936 FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 Q5004936 KB5004936 November 22, 2021
• 5007381 FIX: Sp_execute_external_script fails after you configure new runtime and remove a new Cumulative Update patch in SQL Server 2017 Q5007381 KB5007381 October 27, 2021
• 5007158 FIX: Access violation occurs when you use LOB data type with columnstore indexes in SQL Server 2017 Q5007158 KB5007158 October 27, 2021
• 5007039 FIX: You encounter error messages 8114 or 22122 when performing change tracking cleanup Q5007039 KB5007039 October 27, 2021
• 5005788 FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled Q5005788 KB5005788 October 5, 2021
• 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
• 5004466 FIX: Update SQL Server 2017 and 2016 CEIP service to send usage and diagnostic data to a new endpoint Q5004466 KB5004466 September 16, 2021
• 4578579 Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 Q4578579 KB4578579 September 16, 2021
• 4551720 FIX: Access violation exception occurs when promoting latches of frequently used database pages in SQL Server 2017 and 2016 Q4551720 KB4551720 September 16, 2021
• 4541303 FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server Q4541303 KB4541303 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
• 4531386 FIX: Assertion occurs when sys.sp_cdc_enable_table is used to enable CDC on column set table in SQL Server 2016 and 2017 Q4531386 KB4531386 September 15, 2021
• 4526524 FIX: SQL update package does not update Local DB files correctly when installed using SqlLocalDb.msi Q4526524 KB4526524 September 15, 2021
• 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server Q4515772 KB4515772 September 15, 2021
• 4506023 FIX: Geocentric Datum of Australia 2020 is added to SQL Server 2017, 2016, and 2014 Q4506023 KB4506023 September 15, 2021
• 4500511 Improvement: Improve CDC supportability and usability with In-Memory Databases Q4500511 KB4500511 September 15, 2021
• 4493329 FIX: Error occurs when sp_addarticle is used to add article for transactional replication to memory-optimized table on subscriber in SQL Server 2017 and 2016 Q4493329 KB4493329 September 15, 2021
• 4480630 Improvement: Enhancement adds sql_statement_post_compile extended event in SQL Server 2017 and 2016 Q4480630 KB4480630 September 15, 2021
• 4046056 FIX: Assertion occurs when you access memory-optimized table through MARS in SQL Server 2017 or 2016 Q4046056 KB4046056 September 15, 2021
• 5006029 FIX: Assertion failure may occur when sp_cleanup_history_table is run in SQL Server 2017 Q5006029 KB5006029 September 14, 2021
• 5004750 FIX: SQL Server often crashes when network.forceencryption property is set to '1' Q5004750 KB5004750 September 14, 2021
• 5004734 FIX: Persisted computed columns not being consistently blocked for Columnstore index Q5004734 KB5004734 September 14, 2021
• 5004573 FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019 Q5004573 KB5004573 September 14, 2021
• 4039592 FIX: Cannot change the password for a SQL Server service account when additional LSA protection is enabled Q4039592 KB4039592 September 14, 2021
• 5004560 FIX: Wrong results during Clustered Columnstore Index alter "index reorganize" in versioned scans in SQL Server 2017 and 2019 Q5004560 KB5004560 August 4, 2021
• 5001045 FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 and 2019 Q5001045 KB5001045 August 4, 2021
• 4589360 FIX: Error when you enable managed or automated backup in SQL Server 2016 and 2017 if "Allow Blob Public Access" is disabled on a storage account Q4589360 KB4589360 July 21, 2021
• 5004767 Improvement: Availability Group DNN listener in SQL Server 2017 Q5004767 KB5004767 July 12, 2021
• 5004646 FIX: Access violation on secondary replica when you drop index from view on primary replica in SQL Server 2017 Q5004646 KB5004646 July 12, 2021
• 5003342 FIX: SQL Server Express LocalDB can't start or connect to shared instances of SQL Server Express LocalDB 2019 or 2017 Q5003342 KB5003342 June 10, 2021
• 4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Q4023170 KB4023170 June 10, 2021
• 4579966 FIX: UTC time for DST time zone in Brazil/Sao Paulo is reported incorrectly in SQL Server 2017 Q4579966 KB4579966 June 7, 2021
• 5001260 Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server Q5001260 KB5001260 May 11, 2021
• 5000715 FIX: Failures with log reader agent occurs when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 Q5000715 KB5000715 May 11, 2021
• 5000651 FIX: Assert failure occurs when concurrent query modifies the same bitmap during clustered columnstore delete bitmap seek in SQL Server 2016 and 2017 Q5000651 KB5000651 May 11, 2021
• 4589350 FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server Q4589350 KB4589350 May 11, 2021
• 5001423 FIX: Delete operation may fail with 7105 error in SQL Server 2017 Q5001423 KB5001423 May 10, 2021
• 4583468 Microsoft SQL Server elevation of privilege vulnerability Q4583468 KB4583468 April 16, 2021
• 5000649 FIX: Wrong results due to undetected concatenation parameters from scalar expression Q5000649 KB5000649 April 7, 2021
• 5001044 FIX: Wrong results occur when you run a query on In-Memory optimized tables in SQL Server Q5001044 KB5001044 April 6, 2021
• 4548523 FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error Q4548523 KB4548523 April 6, 2021
• 4486936 FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server Q4486936 KB4486936 April 6, 2021
• 4585971 FIX: User session is in rollback state indefinitely after it is killed in SQL Server Q4585971 KB4585971 March 18, 2021
• 4568447 FIX: Automatic seeding failure occurs for a secondary replica in SQL Server Q4568447 KB4568447 February 27, 2021
• 4582558 FIX: SQL Server service fails to start in Linux operating system Q4582558 KB4582558 February 25, 2021
• 4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 February 25, 2021
• 3135244 TLS 1.2 support for Microsoft SQL Server Q3135244 KB3135244 February 25, 2021
• 4589372 FIX: "Unexpected Exception" error occurs intermittently when SQL Dialect is used against SSAS Tabular model Q4589372 KB4589372 February 24, 2021
• 4589370 FIX: SSAS 2017 stops responding when you run a DAX query Q4589370 KB4589370 February 24, 2021
• 4589362 FIX: Data source with MultiSubnetFailover=True;ApplicationIntent=ReadOnly properties doesn't route requests to AG in SQL Server 2017 Q4589362 KB4589362 February 24, 2021
• 4589352 FIX: Stored procedure (no SP:CacheInsert in trace) is not cached for database compatibility level 140 or 150 in SQL Server 2017 Q4589352 KB4589352 February 24, 2021
• 4589170 FIX: Indefinite hang during cube processing after applying SSAS 2016 SP2 CU7 Q4589170 KB4589170 February 24, 2021
• 4588977 FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails Q4588977 KB4588977 February 24, 2021
• 4580397 FIX: Incorrect results when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server Q4580397 KB4580397 February 24, 2021
• 4575939 FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server Q4575939 KB4575939 February 24, 2021
• 4571296 Improvement: Option to forcefully turn QDS off by specifying the additional option in ALTER DB command Q4571296 KB4571296 February 24, 2021
• 4569837 FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager Q4569837 KB4569837 February 24, 2021
• 4547890 FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server Q4547890 KB4547890 February 24, 2021
• 4336876 FIX: SQL Server on Linux may not start after trace flag 8809 is enabled Q4336876 KB4336876 February 24, 2021
• 4089718 Improvement: Performance issue when upgrading MDS from SQL Server 2012 to 2016 Q4089718 KB4089718 February 23, 2021
• 4575689 FIX: Incorrect results can occur when you run linked server query with aggregates or joins on table with filtered index on a remote server in SQL Server Q4575689 KB4575689 February 15, 2021
• 4577976 FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017 and 2019 Q4577976 KB4577976 February 11, 2021
• 4577933 FIX: Cascade delete on key values outside of leading table histogram bounds causes index scan in SQL Server 2017 and 2019 Q4577933 KB4577933 February 11, 2021
• 4577932 FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions Q4577932 KB4577932 February 11, 2021
• 4565944 Improvement: A manual method to set maximum group commit time in SQL Server 2017 and 2019 Q4565944 KB4565944 February 11, 2021
• 4040276 FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 Q4040276 KB4040276 February 9, 2021
• 4510083 On-demand hotfix update package 2 for SQL Server 2017 CU15 Q4510083 KB4510083 February 8, 2021
• 4506633 On-demand hotfix update package for SQL Server 2017 CU15 Q4506633 KB4506633 February 8, 2021
• 4483666 On-demand hotfix update package for SQL Server 2017 CU13 Q4483666 KB4483666 February 8, 2021
• 4488943 Improvement: New trace flag 8089 is available for faster filtered dump in SQL Server 2017 Q4488943 KB4488943 February 4, 2021
• 4481148 FIX: Restore or Restore Verifyonly of a TDE-compressed backup fails with error 33111 and 3013 in SQL Server 2016 and 2017 Q4481148 KB4481148 January 26, 2021
• 4480653 FIX: Error occurs when you run a query that includes a Boolean field against PolyBase external tables in SQL Server 2016 and 2017 Q4480653 KB4480653 January 26, 2021
• 4475322 FIX: "Non-yielding" error occurs when there is a heavy use of prepared statements in SQL Server 2014, 2016 and 2017 Q4475322 KB4475322 January 26, 2021
• 4469554 FIX: Assertion error occurs during restore of compressed backups in SQL Server 2014, 2016 and 2017 Q4469554 KB4469554 January 26, 2021
• 4468103 FIX: Access violation occurs in Distribution Agent in SQL Server 2016 and 2017 Q4468103 KB4468103 January 26, 2021
• 4467273 FIX: Bad plan error occurs and query fails when you use Adaptive Join to run a query in SQL Server 2017 Q4467273 KB4467273 January 26, 2021
• 4465832 FIX: Rebuilding an Index with Resumable Online Index Rebuild can result in a fragmented index in SQL Server 2017 Q4465832 KB4465832 January 26, 2021
• 4465745 FIX: Assertion error occurs when you run a MERGE statement with an OUTPUT clause in SQL Server 2016 and 2017 Q4465745 KB4465745 January 26, 2021
• 4462767 FIX: A dump file is generated when you run DBCC CHECKDB on a database that has tables with clustered columnstore index in SQL Server 2017 Q4462767 KB4462767 January 26, 2021
• 4461562 FIX: Transactions and log truncation may be blocked when you use Query Store in SQL Server 2016 and 2017 Q4461562 KB4461562 January 26, 2021
• 4460112 FIX: Access violation when you run a query that uses the XML data type in SQL Server 2014, 2016 and 2017 Q4460112 KB4460112 January 26, 2021
• 4459900 FIX: Synchronization fails when you stop primary replica and fail over a secondary replica to primary in Read-Scale AG in SQL Server 2017 Q4459900 KB4459900 January 26, 2021
• 4459709 FIX: Poor performance occurs when you run a query against columnstore in an RCSI-enabled database in SQL Server 2016 and 2017 Q4459709 KB4459709 January 26, 2021
• 4459575 FIX: Error occurs when you delete a record in an entity that has "Approval Required" permission enabled in SQL Server 2017 MDS Q4459575 KB4459575 January 26, 2021
• 4459220 FIX: Incorrect results occur when you convert "pollinginterval" parameter from seconds to hours in sys.sp_cdc_scan in SQL Server Q4459220 KB4459220 January 26, 2021
• 4457953 FIX: Access violations and unhandled exceptions when you set automatic seeding for secondary replica or Distributed Availability Group replica in SQL Server Q4457953 KB4457953 January 26, 2021
• 4346812 FIX: Error occurs when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2017 Q4346812 KB4346812 January 26, 2021
• 4346803 FIX: Error occurs when you run sp_send_dbmail stored procedure that contains comma in sender email address and name in SQL Server Q4346803 KB4346803 January 26, 2021
• 4346643 FIX: Errors 3212 and 3013 occur when you backup a database using MIRROR TO DISK option in SQL Server 2017 Q4346643 KB4346643 January 26, 2021
• 4346330 FIX: Delete operation doesn't work in an entity when you enable Approval Required permission in SQL Server 2017 Master Data Services Q4346330 KB4346330 January 26, 2021
• 4345524 FIX: Create and update don’t work in an entity when you set Read and Create permission in MDS 2017 Q4345524 KB4345524 January 26, 2021
• 4345228 FIX: Slow performance in SQL Server 2017 when you run a query that contains HASHBYTES function when compared to SQL Server 2016 Q4345228 KB4345228 January 26, 2021
• 4342424 Improvement: Update to support QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n in USE HINT option in SQL Server 2017 Q4342424 KB4342424 January 26, 2021
• 4341398 FIX: Event notifications for AUDIT_LOGIN and AUDIT_LOGIN_FAILED events will cause an unusual growth of TempDB in SQL Server 2016 and 2017 Q4341398 KB4341398 January 26, 2021
• 4340746 FIX: No records are returned when you run an MDX query after restarting SSAS 2016 and 2017 Q4340746 KB4340746 January 26, 2021
• 4338890 FIX: "Non-yielding Scheduler" error and SQL Server appears unresponsive in SQL Server 2014, 2016 and 2017 Q4338890 KB4338890 January 26, 2021
• 4338761 FIX: SQL Server may generate EXCEPTION_ACCESS_VIOLATION dump file when you merge two partitions of system-versioned temporal tables in SQL Server 2016 or 2017 Q4338761 KB4338761 January 26, 2021
• 4338715 FIX: Many xml_deadlock_report events are reported for one single intra-query deadlock occurrence in SQL Server 2016 and 2017 Q4338715 KB4338715 January 26, 2021
• 4316858 FIX: "Corrupted index" message and server disconnection when an update statistics query uses hash aggregate on SQL Server Q4316858 KB4316858 January 26, 2021
• 4131496 Improvement: Enable "forced flush" mechanism in SQL Server 2017 on Linux Q4131496 KB4131496 January 26, 2021
• 4101323 FIX: Errors occur when you upgrade to SQL Server 2017 CU4 or later versions and don't enable SQL Server Agent on Linux Q4101323 KB4101323 January 26, 2021
• 4100918 FIX: SQL Server Agent cannot connect to SQL Server 2017 on Docker when non-default TCP port is used Q4100918 KB4100918 January 26, 2021
• 4100873 FIX: Database Mail cannot connect to SQL Server 2017 on Linux when non-default TCP port is used Q4100873 KB4100873 January 26, 2021
• 4100582 FIX: Sensitive data may be exposed when you enable DDM function in SQL Server 2016 and 2017 Q4100582 KB4100582 January 26, 2021
• 4099919 Transparent Data Encryption added for Log Shipping in SQL Server 2016 and 2017 Q4099919 KB4099919 January 26, 2021
• 4099472 PFS page round robin algorithm improvement in SQL Server 2014, 2016 and 2017 Q4099472 KB4099472 January 26, 2021
• 4099334 FIX: Incorrect user name is displayed when a user logs in MDS and accesses Users and Groups functional area in SQL Server 2017 Q4099334 KB4099334 January 26, 2021
• 4098732 FIX: A calculation error occurs when a secured measure is queried in SSAS 2017 Q4098732 KB4098732 January 26, 2021
• 4096258 FIX: An unexpected exception occurs, SSAS crashes when you run a DAX function in SQL Server 2017 Q4096258 KB4096258 January 26, 2021
• 4092667 FIX: Errors 1921 and 1750 when you create a node or edge table in database that has binary collation in SQL Server 2017 Q4092667 KB4092667 January 26, 2021
• 4091722 FIX: Pacemaker promotes an unsynchronized replica to primary when you use AlwaysOn AG in SQL Server 2017 on Linux Q4091722 KB4091722 January 26, 2021
• 4091245 FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016 Q4091245 KB4091245 January 26, 2021
• 4091063 FIX: Access violation occurs when Query Store collects runtime statistics in SQL Server 2017 Q4091063 KB4091063 January 26, 2021
• 4090789 FIX: In-Memory OLTP database takes a long time to recover in SQL Server 2017 Q4090789 KB4090789 January 26, 2021
• 4090486 FIX: Managed Backup fails when database is renamed with trailing white space in SQL Server 2016 and 2017 Q4090486 KB4090486 January 26, 2021
• 4090032 FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode Q4090032 KB4090032 January 26, 2021
• 4090004 Improvement: Configure SESSION_TIMEOUT value for a Distributed Availability Group replica in SQL Server 2016 and 2017 Q4090004 KB4090004 January 26, 2021
• 4089950 Update to support partition elimination in query plans that have spatial indexes in SQL Server 2016 and 2017 Q4089950 KB4089950 January 26, 2021
• 4089948 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2016 or 2017 Q4089948 KB4089948 January 26, 2021
• 4089819 FIX: "A time-out occurred while waiting for buffer latch -- type 4" error when you use Availability Groups in SQL Server 2016 or 2017 Q4089819 KB4089819 January 26, 2021
• 4089623 FIX: Out of memory occurs and query fails when you run MDX query with NON EMPTY option in SSAS Q4089623 KB4089623 January 26, 2021
• 4089473 Better intra-query parallelism deadlocks troubleshooting in SQL Server 2017 and 2016 Q4089473 KB4089473 January 26, 2021
• 4089324 FIX: Error 15665 when you call sp_set_session_context repeatedly with null key value in SQL Server 2016 and 2017 Q4089324 KB4089324 January 26, 2021
• 4089239 FIX: QRY_PROFILE_LIST_MUTEX is blocked when TF 7412 is enabled in SQL Server 2016 and 2017 Q4089239 KB4089239 January 26, 2021
• 4088193 FIX: Slow restore performance when restoring a compressed backup on a disk with 4K sector size in SQL Server Q4088193 KB4088193 January 26, 2021
• 4086136 FIX: SSAS stops responding when you run an MDX query in SQL Server 2016 and 2017 Analysis Services (Multidimensional model) Q4086136 KB4086136 January 26, 2021
• 4083949 FIX: SSAS may crash when you run a DAX query by using a non-admin Windows user in SQL Server 2016 and 2017 Q4083949 KB4083949 January 26, 2021
• 4078596 FIX: Random access violations occur when you run monitoring stored procedure in SQL Server 2016 and 2017 Q4078596 KB4078596 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
• 4078288 FIX: PREDICT function does not return error message for missing columns or handle learning parameter for Tree/Forest models in SQL Server 2017 ML Services Q4078288 KB4078288 January 26, 2021
• 4078097 FIX: NEWSEQUENTIALID function generates duplicate GUID after SQL Server 2017 on Linux is restarted Q4078097 KB4078097 January 26, 2021
• 4078096 FIX: SQL Server shuts down after restart if C2 audit mode is enabled Q4078096 KB4078096 January 26, 2021
• 4078095 Improvement: Improves the performance of SQL Server 2017 on smaller systems Q4078095 KB4078095 January 26, 2021
• 4077105 FIX: Out of memory error when the virtual address space of the SQL Server process is very low in SQL Server Q4077105 KB4077105 January 26, 2021
• 4075203 FIX: Memory ramp-up phase is too long after TF 834 is enabled in SQL Server 2017 on Linux Q4075203 KB4075203 January 26, 2021
• 4074661 FIX: Compatibility level of msdb database remains at 130 when you do a slipstream upgrade to SQL Server 2017 Q4074661 KB4074661 January 26, 2021
• 4058747 FIX: Error when upgrading SSIS catalog database in SQL Server 2016 and 2017 Standard Edition Q4058747 KB4058747 January 26, 2021
• 4058289 FIX: ALTER PROCEDURE WITH ENCRYPTION statement fails when you encrypt a non-published stored procedure in SQL Server 2016 and 2017 Q4058289 KB4058289 January 26, 2021
• 4058175 FIX: TDE-enabled backup and restore are slow if the encryption key is stored in an EKM provider in SQL Server Q4058175 KB4058175 January 26, 2021
• 4058174 FIX: Heavy tempdb contention occurs in SQL Server 2016 or 2017 Q4058174 KB4058174 January 26, 2021
• 4057759 FIX: Internal error when you drill down hierarchy members in SSAS 2016 and 2017 in multidimensional mode Q4057759 KB4057759 January 26, 2021
• 4057615 FIX: "Incorrect syntax near the keyword 'KEY'" error when you add an Oracle table with primary column named 'KEY' in SQL Server 2016 and 2017 Q4057615 KB4057615 January 26, 2021
• 4057190 FIX: Error 14684 when you reconfigure Management Data Warehouse in a named instance of SQL Server 2016 and 2017 Q4057190 KB4057190 January 26, 2021
• 4057087 FIX: Unable to restore a database by using REPLACE option if the filepath contains redundant path separators in SQL Server 2017 Q4057087 KB4057087 January 26, 2021
• 4057055 FIX: A deadlock occurs when you run a parallel query on a clustered columnstore index in SQL Server 2016 and 2017 Q4057055 KB4057055 January 26, 2021
• 4057054 FIX: CXPACKET and CXCONSUMER wait types show inconsistent results for some parallel query plans in SQL Server 2016 and 2017 Q4057054 KB4057054 January 26, 2021
• 4056955 FIX: Queries that casts string or binary data to XML take a long time to compile in SQL Server 2016 and 2017 Q4056955 KB4056955 January 26, 2021
• 4056922 FIX: Unnecessary failover when you use AlwaysOn Availability Group in SQL Server 2017 on Linux Q4056922 KB4056922 January 26, 2021
• 4056821 FIX: Log shipping fails when you use it together with Always On Availability Groups in SQL Server 2016 and 2017 Q4056821 KB4056821 January 26, 2021
• 4056354 FIX: Mirroring session stops synchronizing after doing rolling upgrade to SQL Server 2017 Q4056354 KB4056354 January 26, 2021
• 4056328 FIX: Performance Counters are missing after the installation of SSAS 2017 in tabular mode Q4056328 KB4056328 January 26, 2021
• 4056117 FIX: Assertion occurs when you pass memory-optimized table variable into a stored procedure as table-valued parameter in SQL Server 2016 and 2017 Q4056117 KB4056117 January 26, 2021
• 4055758 FIX: Inconsistent behavior for returning trailing blanks at the end of CHAR and BINARY data in SQL Server Q4055758 KB4055758 January 26, 2021
• 4055735 FIX: DBCC CHECKDB returns consistency errors if SOUNDEX function is used in PERSISTED computed columns in SQL Server Q4055735 KB4055735 January 26, 2021
• 4055727 FIX: Recovery of database takes a long time when it contains memory-optimized tables in SQL Server 2016 and 2017 Q4055727 KB4055727 January 26, 2021
• 4055674 FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 and 2017 Integration Services Q4055674 KB4055674 January 26, 2021
• 4055456 FIX: "Incompletely installed" error on Feature Selection page when you modify the current installation of SQL Server 2016 SP1 or SQL Server 2016 SP1 CU5 Q4055456 KB4055456 January 26, 2021
• 4055281 FIX: "Msg 3948" error when you run a query on secondary replica of secondary availability group in SQL Server 2016 and 2017 Q4055281 KB4055281 January 26, 2021
• 4054842 Improvement: General improvements to the change tracking cleanup process in SQL Server 2016 and 2017 Q4054842 KB4054842 January 26, 2021
• 4054398 FIX: "Invalid comparison due to NO COLLATION" retail assert occurs in SQL Server 2014, 2016, and 2017 Q4054398 KB4054398 January 26, 2021
• 4054037 FIX: Fatal error when a natively compiled stored procedure is executed to access memory-optimized tables in SQL Server 2017 Q4054037 KB4054037 January 26, 2021
• 4053550 FIX: Processing XML message through Service Broker results in hung session in SQL Server 2016 and 2017 Q4053550 KB4053550 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
• 4053407 FIX: SQL Server 2017 cannot decrypt data encrypted by earlier versions of SQL Server by using the same symmetric key Q4053407 KB4053407 January 26, 2021
• 4053392 FIX: Name resolution error occurs when IPv6 is disabled on startup in SQL Server 2017 on Linux Q4053392 KB4053392 January 26, 2021
• 4053386 FIX: Using ALTER TABLE on an in-memory optimized table crashes SQL Server 2017 Q4053386 KB4053386 January 26, 2021
• 4053349 FIX: "sys.external_libraries" catalog views are empty for non-dbo users in SQL Server Q4053349 KB4053349 January 26, 2021
• 4053348 FIX: External R library is installed or uninstalled repeatedly in SQL Server Q4053348 KB4053348 January 26, 2021
• 4053329 FIX: Deadlock occurs when multiple PREDICT T-SQL functions run concurrently in SQL Server 2017 Q4053329 KB4053329 January 26, 2021
• 4052984 FIX: Error when you backup database with memory-optimized tables in SQL Server 2017 Q4052984 KB4052984 January 26, 2021
• 4052972 FIX: CT auto cleanup is stuck and not working in SQL Server 2017 Q4052972 KB4052972 January 26, 2021
• 4052969 FIX: Minimum memory limit set to 2GB to install or start SQL Server 2017 Q4052969 KB4052969 January 26, 2021
• 4052938 FIX: DST changes of Sao Paulo time zone are not determined by SQL Server 2017 on Linux Q4052938 KB4052938 January 26, 2021
• 4052697 FIX: TLS cipher suites with PFS don't work for secure connections in SQL Server 2017 on Linux Q4052697 KB4052697 January 26, 2021
• 4052572 FIX: SSAS 2016 and 2017 crashes intermittently when you rename a multidimensional database by using script Q4052572 KB4052572 January 26, 2021
• 4052131 FIX: DMV sys.dm_os_windows_info returns wrong values for Windows 10 and Windows Server 2016 Q4052131 KB4052131 January 26, 2021
• 4052129 Update for manual change tracking cleanup procedure in SQL Server 2014, 2016 and 2017 Q4052129 KB4052129 January 26, 2021
• 4052123 FIX: Sliding expiration for authentication cookie isn't working and fails to redirect to logon page in SSRS 2016 and 2017 Q4052123 KB4052123 January 26, 2021
• 4052122 Performance improvement for Spatial Internal Filter in SQL Server 2017 Q4052122 KB4052122 January 26, 2021
• 4051361 Optimizer row goal information in query execution plan added in SQL Server 2014, 2016 and 2017 Q4051361 KB4051361 January 26, 2021
• 4051356 FIX: In-memory database restore fails with errors in SQL Server 2016 and SQL Server 2017 Q4051356 KB4051356 January 26, 2021
• 4049027 FIX: "AdomdConnectionException" error when SSRS 2016 and 2017 data source uses msmdpump.dll Q4049027 KB4049027 January 26, 2021
• 4048967 FIX: Can't enable or disable change data capture for a database after you attach it in SQL Server 2014, 2016, or 2017 Q4048967 KB4048967 January 26, 2021
• 4048943 FIX: Access violation occurs on primary replica of AlwaysOn Availability Group in SQL Server Q4048943 KB4048943 January 26, 2021
• 4048942 FIX: Memory dumps generated for "Stalled IOCP Listener" and "non-yielding IOCP listener" after SQL Server restart Q4048942 KB4048942 January 26, 2021
• 4046918 FIX: Execution fails when a SQL CLR function invokes Transact-SQL statements through impersonation calls in SQL Server 2016 and 2017 Q4046918 KB4046918 January 26, 2021
• 4046914 FIX: Add CXPACKET wait type in showplan XML in SQL Server 2016 and 2017 Q4046914 KB4046914 January 26, 2021
• 4046745 FIX: UPDATE statement fails silently when you reference a nonexistent partition function in the WHERE clause in SQL Server 2014, 2016, or 2017 Q4046745 KB4046745 January 26, 2021
• 4046065 FIX: Memory corruption occurs during Availability Group failovers for DTC transactions in SQL Server 2017 Q4046065 KB4046065 January 26, 2021
• 4046044 FIX: Unable to install SQL Server 2017 when instance name/ID/installation path contains multi-byte characters Q4046044 KB4046044 January 26, 2021
• 4046022 FIX: Automatic Tuning settings cannot be configured on ModelDB in SQL Server 2017 Q4046022 KB4046022 January 26, 2021
• 4045678 FIX: Unexpected error when you use the DReplay feature to replay a captured trace in SQL Server 2017 Q4045678 KB4045678 January 26, 2021
• 4045329 Fix: Error when a stored procedure passes a memory-optimized table to an inline table-valued function in SQL Server 2017 Q4045329 KB4045329 January 26, 2021
• 4044064 FIX: "Request timed out" error when you change security options for an MDS security group in SQL Server 2016 and 2017 Q4044064 KB4044064 January 26, 2021
• 4043947 FIX: Bookmarks functionality does not work completely when you open a report in MHTML format through Outlook in SSRS Q4043947 KB4043947 January 26, 2021
• 4043624 FIX: Change tracking manual cleanup fails with table non-existence error in SQL Server Q4043624 KB4043624 January 26, 2021
• 4042885 FIX: Divide-by-zero error when a parallel query is forced to run in serial mode in SQL Server 2017 Q4042885 KB4042885 January 26, 2021
• 4042232 FIX: Access violation when you cancel a pending query if the missing indexes feature is enabled in SQL Server Q4042232 KB4042232 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
• 4041811 FIX: Automatic update of incremental statistics is delayed in SQL Server 2014, 2016 and 2017 Q4041811 KB4041811 January 26, 2021
• 4041809 Update adds support for MAXDOP option for CREATE STATISTICS and UPDATE STATISTICS statements in SQL Server 2014, 2016 and 2017 Q4041809 KB4041809 January 26, 2021
• 4041553 SQL Server Service Packs are discontinued starting from SQL Server 2017 Q4041553 KB4041553 January 26, 2021
• 4040533 FIX: Returns incorrect results when computed column is queried after installing hotfix that's described in KB 3213683 and enabling TF 176 in SQL Server 2016 or 2017 Q4040533 KB4040533 January 26, 2021
• 4040531 FIX: Constraint violation error returned by the managed_backup.fn_available_backups function after you install the Cumulative Update 2 for SQL Server 2016 SP1 Q4040531 KB4040531 January 26, 2021
• 4039966 FIX: Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command in SQL Server 2016 or 2017 Q4039966 KB4039966 January 26, 2021
• 4039776 FIX: Incorrect behavior when you use memory-optimized tables with "where exists" statement in SQL Server 2016 or 2017 Q4039776 KB4039776 January 26, 2021
• 4039736 FIX: SSIS package does not start when it's run by a CLR stored procedure whose user does not have SYSADMIN permissions Q4039736 KB4039736 January 26, 2021
• 4039511 FIX: Managed Backup fails intermittently because of SQLVDI error in SQL Server Q4039511 KB4039511 January 26, 2021
• 4039510 FIX: Access violation occurs when you use sp_xml_preparedocument to open XML documents in SQL Server Q4039510 KB4039510 January 26, 2021
• 4039509 FIX: SSAS crashes when you process an SSAS database or cube in SQL Server Q4039509 KB4039509 January 26, 2021
• 4039284 Enhancement: New keyword is added to CREATE and UPDATE STATISTICS statements to persist sampling rate for future statistics updates in SQL Server Q4039284 KB4039284 January 26, 2021
• 4039124 FIX: Memory spike in LSASS.EXE when you enable Basic Authentication mode in SSRS 2016 or 2017 Q4039124 KB4039124 January 26, 2021
• 4039089 FIX: EXCEPTION_ACCESS_VIOLATION error when you execute the sys.sp_MScdc_capture_job stored procedure in SQL Server Q4039089 KB4039089 January 26, 2021
• 4039058 FIX: Report Viewer Web Part does not allow a full vertical scrollbar after you set a specific web part height Q4039058 KB4039058 January 26, 2021
• 4038882 FIX: SQL Server Managed Backup does not delete old backups that are beyond the retention period in SQL Server Q4038882 KB4038882 January 26, 2021
• 4038881 FIX: Unexpected exception occurs when you process dimensions by using Process Update in SSAS 2016 or SSAS 2017 Q4038881 KB4038881 January 26, 2021
• 4038590 FIX: SSIS package that contains German umlauts fails on execution after Incremental Package Deployment in SQL Server 2016 or 2017 Q4038590 KB4038590 January 26, 2021
• 4038419 Update adds CPU timeout setting to Resource Governor workgroup REQUEST_MAX_CPU_TIME_SEC in SQL Server 2014, 2016 and 2017 Q4038419 KB4038419 January 26, 2021
• 4038113 FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server Q4038113 KB4038113 January 26, 2021
• 4037454 FIX: Policy-Based Management policy isn't working after you install CU2 for SQL Server 2016 SP1 Q4037454 KB4037454 January 26, 2021
• 4037412 FIX: Error when SQL Server replication article contains either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID Q4037412 KB4037412 January 26, 2021
• 4034789 FIX: An unexpected exception error occurs when a XIRR measure processes too many records in SSAS 2016 or 2017 Q4034789 KB4034789 January 26, 2021
• 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server Q4034376 KB4034376 January 26, 2021
• 4033789 FIX: A memory leak may occur when you perform Process Update operations in SSAS Q4033789 KB4033789 January 26, 2021
• 4032543 FIX: SSAS crashes when you run a DAX or MDX query in SSAS in Tabular mode Q4032543 KB4032543 January 26, 2021
• 4025402 FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2017 and SQL Server 2016 Q4025402 KB4025402 January 26, 2021
• 4025020 FIX: SUSER_SNAME function returns different results between SQL Server 2014 and SQL Server 2016 or 2017 Q4025020 KB4025020 January 26, 2021
• 4024622 FIX: Couldn't truncate a partition of the partitioned table if it contains an extended or XML index in SQL Server 2016 or 2017 Q4024622 KB4024622 January 26, 2021
• 4024393 FIX: Assertion error occurs on the secondary replica when you resume a suspended availability database in SQL Server 2016 or 2017 Q4024393 KB4024393 January 26, 2021
• 4024023 FIX: SSAS crashes when you access .vmp files in SQL Server 2017 and SQL Server 2016 Q4024023 KB4024023 January 26, 2021
• 4023995 FIX: A data mask on a floating points column is not applied in SQL Server 2017 and SQL Server 2016 Q4023995 KB4023995 January 26, 2021
• 4023926 FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server Q4023926 KB4023926 January 26, 2021
• 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server MDS Q4023865 KB4023865 January 26, 2021
• 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server is also installed Q4022895 KB4022895 January 26, 2021
• 4022753 FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Q4022753 KB4022753 January 26, 2021
• 4022483 FIX: Error when you export a DQS knowledge base that contains domains in the DQS client in SQL Server Q4022483 KB4022483 January 26, 2021
• 4019840 FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2016 and 2017 Q4019840 KB4019840 January 26, 2021
• 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) Q4018908 KB4018908 January 26, 2021
• 4017445 FIX: A REDO thread is not available in the secondary replica after an availability database is dropped in SQL Server Q4017445 KB4017445 January 26, 2021
• 3216543 FIX: Workloads that utilize many frequent, short transactions in SQL Server 2016 and 2017 may consume more CPU than in SQL Server 2014 Q3216543 KB3216543 January 26, 2021
• 3208545 FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation Q3208545 KB3208545 January 26, 2021
• 3192154 A non-optimal query plan choice causes poor performance when values outside the range represented in statistics are searched in SQL Server 2016 and 2017 Q3192154 KB3192154 January 26, 2021
• 3177838 How to use DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server Q3177838 KB3177838 January 26, 2021
• 3156157 Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available Q3156157 KB3156157 January 26, 2021
• 3147012 FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads Q3147012 KB3147012 January 26, 2021
• 3028216 FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS Q3028216 KB3028216 January 26, 2021
• 3026083 FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server Q3026083 KB3026083 January 26, 2021
• 3010148 FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Q3010148 KB3010148 January 26, 2021
• 2932559 FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS Q2932559 KB2932559 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
• 4293805 Description of the security update for the remote code execution vulnerability in SQL Server 2017 (CU): August 14, 2018 Q4293805 KB4293805 January 25, 2021
• 4293803 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2017 (GDR): August 14, 2018 Q4293803 KB4293803 January 25, 2021
• 3180087 Poor performance when you run INSERT.. SELECT operations in SQL Server 2016 or SQL Server 2017 on Windows Q3180087 KB3180087 January 25, 2021
• 3108695 Client connectivity issues because of changes in name resolution in SQL Server 2014 or later Q3108695 KB3108695 January 25, 2021
• 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
• 4583457 Description of the security update for SQL Server 2017 CU22: January 12, 2021 Q4583457 KB4583457 January 16, 2021
• 4583456 Description of the security update for SQL Server 2017 GDR: January 12, 2021 Q4583456 KB4583456 January 16, 2021
• 4563007 FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4 or SQL Server 2017 CU19/CU20/CU21 Q4563007 KB4563007 January 14, 2021
• 4505225 Description of the security update for SQL Server 2017 CU15: July 9, 2019 Q4505225 KB4505225 January 14, 2021
• 4505224 Description of the security update for SQL Server 2017 GDR: July 9, 2019 Q4505224 KB4505224 January 14, 2021
• 4497700 Restricted data is not protected correctly by OLS in SQL Server 2017 Analysis Services Q4497700 KB4497700 January 14, 2021
• 4494352 Description of the security update for SQL Server 2017 CU 14 GDR: May 14, 2019 Q4494352 KB4494352 January 14, 2021
• 4494351 Description of the security update for SQL Server 2017 GDR: May 14, 2019 Q4494351 KB4494351 January 14, 2021
• 4480709 FIX: Error 18204 during automatic backup in virtual machines when the backup file is split into multiple files Q4480709 KB4480709 January 14, 2021
• 4480648 FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object Q4480648 KB4480648 January 14, 2021
• 4480647 Update adds improvements and fixes issues when you use an Oracle RAC environment in SQL Server Q4480647 KB4480647 January 14, 2021
• 4480645 FIX: Access violation when you query by using “sys.dm_db_tuning_recommendations” in SQL Server Q4480645 KB4480645 January 14, 2021
• 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition Q4480639 KB4480639 January 14, 2021
• 4479283 FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster Q4479283 KB4479283 January 14, 2021
• 4471213 FIX: Primary replica databases display "NOT SYNCHRONIZING" status when all replicas in AG use synchronous commit availability mode in SQL Server 2017 Q4471213 KB4471213 January 14, 2021
• 4470411 FIX: Designing a parameterized DAX query in Report Builder Query Designer generates an exception in SSAS Q4470411 KB4470411 January 14, 2021
• 4469942 FIX: Sharing violation when the "sp_cycle_agent_errorlog" stored procedure is run in SQL Server Q4469942 KB4469942 January 14, 2021
• 4469292 FIX: Cannot connect to the MDS database by using the MDS Add-in for Microsoft Excel Q4469292 KB4469292 January 14, 2021
• 4469268 FIX: I/O error on a BPE file causes buffer time-out in SQL Server Q4469268 KB4469268 January 14, 2021
• 4469140 FIX: "Could not find server" when the publisher database name contains a period in SQL Server 2017 Q4469140 KB4469140 January 14, 2021
• 4468102 FIX: Excessive memory usage when you trace RPC events that involve Table-Valued Parameters in SQL Server 2016 and 2017 Q4468102 KB4468102 January 14, 2021
• 4467449 FIX: Pacemaker can't manage cluster resources in an Always On Availability Group in SQL Server Q4467449 KB4467449 January 14, 2021
• 4467074 Update disables trace flag 2467 at session level to prevent a performance issue for parallel queries in SQL Server 2017 Q4467074 KB4467074 January 14, 2021
• 4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016 and 2017 Q4466994 KB4466994 January 14, 2021
• 4466962 FIX: SQL Server 2017 crashes when you use third-party Active Directory providers Q4466962 KB4466962 January 14, 2021
• 4466831 FIX: “A connection cannot be made” error when SSIS package uses a parameterized connection manager in SQL Server 2016 and 2017 Q4466831 KB4466831 January 14, 2021
• 4466108 FIX: Backing up a SQL Server database by using a VSS backup application may fail after installing SQL Server 2016 and 2017 Q4466108 KB4466108 January 14, 2021
• 4465867 FIX: "ran out of memory" error when executing a query on a table that has a large full-text index in SQL Server 2014, 2016 and 2017 Q4465867 KB4465867 January 14, 2021
• 4465248 FIX: “An unexpected exception occurred” in an MDX query for PC dimensions in SSAS 2017 Q4465248 KB4465248 January 14, 2021
• 4465236 FIX: Access violation occurs in compile code when you parse the forced plan in SQL Server 2016 and 2017 Q4465236 KB4465236 January 14, 2021
• 4465204 FIX: An intra-query deadlock occurs in a query containing UNION ALL in batch mode in SQL Server Q4465204 KB4465204 January 14, 2021
• 4463757 FIX: "Encryption not supported on the client" error when a SQL Server 2017 linked server query fails Q4463757 KB4463757 January 14, 2021
• 4463314 Update improves SQL server performance by restricting which KDC can be contacted in geographically large networks Q4463314 KB4463314 January 14, 2021
• 4463125 FIX: Error occurs when the Database Encryption Key is longer than 3,456 bits in SQL Server 2016 and 2017 Q4463125 KB4463125 January 14, 2021
• 4462699 FIX: Derived hierarchies not working in SQL Server 2017 MDS Add-in for Microsoft Excel Q4462699 KB4462699 January 14, 2021
• 4462481 FIX: Query operation freezes when you insert data into a clustered columnstore index in parallel in SQL Server data warehousing Q4462481 KB4462481 January 14, 2021
• 4460116 FIX: Overestimations when using default Cardinality Estimator to query table with many null values Q4460116 KB4460116 January 14, 2021
• 4459981 FIX: Access violation occurs and SSAS crashes when you process an SSAS database in SQL Server 2014, 2016 and 2017 Q4459981 KB4459981 January 14, 2021
• 4459327 FIX: Error 41317 when you enable server audit and you use in-memory transactions in SQL Server Q4459327 KB4459327 January 14, 2021
• 4458880 FIX: “9003 error, sev 20, state 1” error when a backup operation fails on a secondary replica that is running under asynchronous-commit mode Q4458880 KB4458880 January 14, 2021
• 4458438 FIX: The SQL Service shuts down after SP2 is installed on SQL Server 2016 and 2017 with c2 audit mode enabled Q4458438 KB4458438 January 14, 2021
• 4458316 FIX: "Internal error: An unexpected error occurred" when you run an MDX query that was generated by Excel in SSAS Q4458316 KB4458316 January 14, 2021
• 4456883 FIX: Change Tracking cleanup message 22123 is unexpectedly recorded in the error log file in SQL Server Q4456883 KB4456883 January 14, 2021
• 4456775 FIX: Can't retrieve ConnectionID and SPID when running an SSAS Profiler trace in SQL Server Q4456775 KB4456775 January 14, 2021
• 4347088 FIX: Out of memory error occurs even when there are many free pages in SQL Server Q4347088 KB4347088 January 14, 2021
• 4347055 FIX: Out of memory error when you run SQL Server 2017 in a Linux Docker container Q4347055 KB4347055 January 14, 2021
• 4345683 FIX: A value set for the “Accepted NTLM SPNs” variable causes an access violation during startup of SQL Server 2017 Q4345683 KB4345683 January 14, 2021
• 4345402 FIX: Synchronization of a database takes a long time to finish in SQL Server 2017 Q4345402 KB4345402 January 14, 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
• 4344103 FIX: MEMORYCLERK_SOSMEMMANAGER grows larger and FAIL_PAGE_ALLOCATION error is logged after you enable large page allocations Q4344103 KB4344103 January 14, 2021
• 4342111 Update adds improved support for SAP HANA data sources in SQL Server Analysis Services Q4342111 KB4342111 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
• 4341221 FIX: VSS backup fails in secondary replica of Basic Availability Groups in SQL Server 2016 and 2017 Q4341221 KB4341221 January 14, 2021
• 4341219 FIX: A split-brain scenario occurs after a failover when using AlwaysOn Availability Groups with external cluster technology in SQL Server 2017 Q4341219 KB4341219 January 14, 2021
• 4340747 FIX: SQLDUMPER.EXE-initiated dumps take a long time to finish in SQL Server 2017 on Linux Q4340747 KB4340747 January 14, 2021
• 4340069 FIX: SQL Server 2017 on Linux shuts down unexpectedly during the recovery of an In-Memory OLTP database Q4340069 KB4340069 January 14, 2021
• 4339858 FIX: Parallel redo does not work after you disable Trace Flag 3459 in an instance of SQL Server Q4339858 KB4339858 January 14, 2021
• 4339664 FIX: Exception error occurs when you try to refresh data for a pivot table in Excel in SSAS 2017 Q4339664 KB4339664 January 14, 2021
• 4339613 FIX: “Unclosed quotation mark after the character string” error in the MDS explorer when you try to add a new member to an entity in SQL Server Q4339613 KB4339613 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
• 4338746 FIX: Error 19432 when you use Always On Availability Groups in SQL Server Q4338746 KB4338746 January 14, 2021
• 4338576 FIX: Transaction delays on the primary replica if database synchronization is reported incorrectly on a secondary replica in SQL Server Q4338576 KB4338576 January 14, 2021
• 4338337 FIX: SQL Server crashes and then restarts when the “Adaptive join” option is enabled Q4338337 KB4338337 January 14, 2021
• 4338330 FIX: CASE expressions containing identical sub-queries may return incorrect results in SQL Server 2017 Q4338330 KB4338330 January 14, 2021
• 4337645 FIX: Error 883 occurs when a database that belongs to an availability group is marked as SUSPECT in SQL Server 2017 on Linux Q4337645 KB4337645 January 14, 2021
• 4316948 FIX: Access violation when you compile a query and histogram amendment is enabled with default Cardinality Estimation in SQL Server 2016 and 2017 Q4316948 KB4316948 January 14, 2021
• 4316793 FIX: Unnecessary failovers occur when a SQL Server 2017 Failover Cluster Instance or Always On AG is managed by Pacemaker Q4316793 KB4316793 January 14, 2021
• 4316791 FIX: Two SQL Server instances are the primary replica of an availability group in SQL Server Q4316791 KB4316791 January 14, 2021
• 4316790 FIX: Startup of a database that belongs to an availability group times out in SQL Server on Linux Q4316790 KB4316790 January 14, 2021
• 4316789 FIX: Always On database is stuck at “Recovery Pending” after the host name of an availability replica is renamed in SQL Server Q4316789 KB4316789 January 14, 2021
• 4316655 FIX: An assertion error occurs when querying dm_db_stats_histogram DMF in SQL Server 2017 Q4316655 KB4316655 January 14, 2021
• 4295097 FIX: Cannot change the “isAvailableInMdx” column property to “False” in SSAS in Tabular mode Q4295097 KB4295097 January 14, 2021
• 4294694 FIX: Access violation when you try to access a table when page compression is enabled on the table in SQL Server Q4294694 KB4294694 January 14, 2021
• 4293761 FIX: Unexpected error when processing a table by using the “Process Full” option in SQL Server Analysis Services Q4293761 KB4293761 January 14, 2021
• 4293576 FIX: "Non-yielding" error when you try to recover an In-Memory database in SQL Server Q4293576 KB4293576 January 14, 2021
• 4230542 FIX: Pacemaker promotion of local replica to primary fails when using AlwaysOn AG in SQL Server 2017 Q4230542 KB4230542 January 14, 2021
• 4230516 FIX: A memory assertion failure occurs, and the server can't make new connections in SQL Server Q4230516 KB4230516 January 14, 2021
• 4230465 FIX: Communication link error when you use datetime2 fields while accessing a database in SQL Server 2017 Q4230465 KB4230465 January 14, 2021
• 4212960 FIX: SQL Server will not start when you run a SQL Server 2017 Linux container image on Docker for Windows Q4212960 KB4212960 January 14, 2021
• 4164562 FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server Q4164562 KB4164562 January 14, 2021
• 4163528 FIX: DAX query performance decrease after you upgrade to SQL Server 2017 Q4163528 KB4163528 January 14, 2021
• 4163526 FIX: A DAX query that contains SWITCH and nested IF statements takes more than an hour to finish in SQL Server Q4163526 KB4163526 January 14, 2021
• 4163478 FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server Q4163478 KB4163478 January 14, 2021
• 4163087 FIX: Performance is slow for an Always On AG when you process a read query in SQL Server Q4163087 KB4163087 January 14, 2021
• 4157948 FIX: Floating point overflow error when you run a nested natively compiled module that uses EXP functions in SQL Server Q4157948 KB4157948 January 14, 2021
• 4136912 Multiple device VDI backup can hang on Linux Q4136912 KB4136912 January 14, 2021
• 4136679 FIX: SQL Server 2017 Analysis Services crashes after a random query is run against DirectQuery mode Q4136679 KB4136679 January 14, 2021
• 4134601 FIX: “Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClientUI” error when a “Process Full” operation is run in SQL Server Q4134601 KB4134601 January 14, 2021
• 4133191 FIX: A memory leak occurs in sqlwepxxx.dll causes the WmiPrvSe.exe process to crash Q4133191 KB4133191 January 14, 2021
• 4132042 FIX: Query performance difference between SSAS 2014 and SSAS 2017 Q4132042 KB4132042 January 14, 2021
• 4131960 FIX: Access violation when you run a nested select query against a columnstore index in SQL Server Q4131960 KB4131960 January 14, 2021
• 4101554 FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error Q4101554 KB4101554 January 14, 2021
• 4101502 FIX: TDE-enabled database backup with compression causes database corruption in SQL Server Q4101502 KB4101502 January 14, 2021
• 4101482 FIX: Automatic seeding fails when using an Always On availability group in SQL Server Q4101482 KB4101482 January 14, 2021
• 4099126 FIX: "Access Violation" error when you execute a complex query with multiple joins and the Adaptive Join feature is enabled in SQL Server Q4099126 KB4099126 January 14, 2021
• 4098763 FIX: R script fails on parallel execution in SQL Server 2017 Q4098763 KB4098763 January 14, 2021
• 4096875 FIX: "Access is denied" error when you try to create a database in SQL Server 2017 Express LocalDB Q4096875 KB4096875 January 14, 2021
• 4094858 FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server Q4094858 KB4094858 January 14, 2021
• 4094706 FIX: Parallel query hangs when a worker thread is aborted in an instance of SQL Server Q4094706 KB4094706 January 14, 2021
• 4093805 FIX: Can't stop the SQL Server Linux Docker container by using the “docker stop” command Q4093805 KB4093805 January 14, 2021
• 4093226 FIX: “DirectQuery may not be used with this data source” error when you browse a Direct Query model in SQL Server Q4093226 KB4093226 January 14, 2021
• 4089946 FIX: SQL Server stops responding when you remove the availability group listener or change their port number Q4089946 KB4089946 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
• 4088901 FIX: Assertion failure when sys.dm_db_log_space_usage statement is run on a database snapshot in SQL Server 2016 and 2017 Q4088901 KB4088901 January 14, 2021
• 4088270 FIX: Big PAGELATCH_EX contentions when you remove temporary objects in SQL Server Q4088270 KB4088270 January 14, 2021
• 4087406 FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014, 2016, and 2017 Q4087406 KB4087406 January 14, 2021
• 4086173 FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Q4086173 KB4086173 January 14, 2021
• 4078303 FIX: Access violation in SSAS when MDX query is executed in SQL Server 2017 Q4078303 KB4078303 January 14, 2021
• 4078098 FIX: Database schemas aren't upgraded or downgraded when you install or uninstall a cumulative update in SQL Server 2017 on Linux Q4078098 KB4078098 January 14, 2021
• 4077899 FIX: PolyBase not installed with SQL Server 2017 because installer doesn't recognize JRE 9 Q4077899 KB4077899 January 14, 2021
• 4077683 FIX: System stored procedure sp_execute_external_script and DMV sys.dm_exec_cached_plans cause memory leaks in SQL Server 2016 and 2017 Q4077683 KB4077683 January 14, 2021
• 4076982 FIX: Pacemaker demotes existing primary replica of an AlwaysOn AG in SQL Server 2017 on Linux and never promotes a new one Q4076982 KB4076982 January 14, 2021
• 4074881 FIX: Assertion error when data is bulk-inserted into a table that contains non-clustered and clustered columnstore indexes in SQL Server 2016 and 2017 Q4074881 KB4074881 January 14, 2021
• 4073684 FIX: Change data capture does not work in SQL Server 2017 Q4073684 KB4073684 January 14, 2021
• 4073670 FIX: Can't create a login based on a user that belongs to the parent domain in SQL Server 2017 on Linux Q4073670 KB4073670 January 14, 2021
• 4073045 FIX: Unexpected memory consumption when TCP protocol connections are used for SQL Server 2017 on Linux Q4073045 KB4073045 January 14, 2021
• 4058700 FIX: Intermittent 9004 error when a backup is restored via Standby Mode in SQL Server 2014, 2016, and 2017 Q4058700 KB4058700 January 14, 2021
• 4058565 FIX: Assertion error when executing a stored procedure that references a large object in SQL Server 2014, 2016, and 2017 Q4058565 KB4058565 January 14, 2021
• 4056154 Update adds execution statistics for scalar-valued, user-defined functions to the actual Showplan XML in SQL Server 2017 Q4056154 KB4056154 January 14, 2021
• 4054036 FIX: Error 8624 when you run a query that contains a SELECT DISTINCT statement on a graph column in SQL Server 2017 on Linux or Windows Q4054036 KB4054036 January 14, 2021
• 4054035 FIX: Error 213 when you merge or split a partition of a partitioned graph table in SQL Server 2017 on Linux or Windows Q4054035 KB4054035 January 14, 2021
• 4053447 FIX: Incorrect prompt to restart SQL Server 2017 on Linux when not required Q4053447 KB4053447 January 14, 2021
• 4053393 FIX: SQL Server 2017 on Linux doesn't listen to nondefault IP address specified by mssql-conf script Q4053393 KB4053393 January 14, 2021
• 4053293 PolyBase support added for SSL-secured Hadoop clusters and access to Encryption Zones Q4053293 KB4053293 January 14, 2021
• 4053291 FIX: "sys.dm_exec_query_profiles" DMV returns wrong "estimate_row_count" in SQL Server 2017 on Linux and Windows Q4053291 KB4053291 January 14, 2021
• 4052633 FIX: SELECT query that uses batch mode hash aggregate operator that counts multiple nullable columns returns bad results in SQL Server Q4052633 KB4052633 January 14, 2021
• 4052625 FIX: Queries that retrieve data by using non-clustered index seek take longer in SQL Server Q4052625 KB4052625 January 14, 2021
• 4052338 FIX: Excessive PREMPTIVE_OS_CREATEDIRECTORY waits during workload that compiles or recompiles memory-optimized tables or table types Q4052338 KB4052338 January 14, 2021
• 4052135 FIX: RESTORE HEADERONLY statement for a TDE compressed backup slow to complete in SQL Server Q4052135 KB4052135 January 14, 2021
• 4052134 FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server Q4052134 KB4052134 January 14, 2021
• 4052127 FIX: Alert Engine reads complete Application event log and sends alerts on old events after Windows is restarted Q4052127 KB4052127 January 14, 2021
• 4052126 Update adds new "marked_transaction_latch_trace" extended event in SQL Server 2017 on Linux and Windows Q4052126 KB4052126 January 14, 2021
• 4046744 FIX: DML statements that use cascading operations fail in SQL Server 2017 Q4046744 KB4046744 January 14, 2021
• 4046638 Add the ability to disable or enable a few new DMVs and DMFs introduced in SQL Server 2017 Q4046638 KB4046638 January 14, 2021
• 4046102 FIX: State of the ForceLastGoodPlan recommendation is falsely reported as Expired if applied manually in SQL Server 2017 Q4046102 KB4046102 January 14, 2021
• 4046099 FIX: Assertion error after creating snapshot backup for database with memory-optimized tables in SQL Server 2017 Q4046099 KB4046099 January 14, 2021
• 4046066 All transactions reported as completed even though some fail while trying to commit in SQL Server 2017 Q4046066 KB4046066 January 14, 2021
• 4046055 FIX: FORCE_LAST_GOOD_PLAN recommendation stuck at "Verifying" at first verification in SQL Server 2017 Q4046055 KB4046055 January 14, 2021
• 4045814 FIX: "Message 611" error when you use BULK INSERT or INSERT SELECT to insert data into a clustered columnstore index Q4045814 KB4045814 January 14, 2021
• 4045687 Update to enable SQL Server 2017 Express edition to act as a witness role in a database mirroring session Q4045687 KB4045687 January 14, 2021
• 4044009 FIX: A deadlock condition occurs when you create a new database in SQL Server 2017 Q4044009 KB4044009 January 14, 2021
• 4043478 FIX: Error when you export an SSRS report on an iOS device in SQL Server 2016 or 2017 Q4043478 KB4043478 January 14, 2021
• 4043455 FIX: Portability and performance differ between Windows and Linux scheduler mappings in SQL Server 2017 Q4043455 KB4043455 January 14, 2021
• 4042962 FIX: "An unknown error" for "Show More Members" on Entity Dependencies explorer page in SQL Server 2016 and 2017 Master Data Services Q4042962 KB4042962 January 14, 2021
• 4042251 FIX: Database mirroring failover fails with error 3456 in SQL Server 2016 or 2017 Q4042251 KB4042251 January 14, 2021
• 4040535 FIX: SQL Server Managed Backups do not run a scheduled log backup in SQL Server 2016 or 2017 Q4040535 KB4040535 January 14, 2021
• 4040530 FIX: Log chain break in the "managed_backup.fn_available_backups" table in SQL Server 2016 or 2017 Q4040530 KB4040530 January 14, 2021
• 4040519 FIX: Automatic seeding in Availability Groups randomly causes error 41169 in SQL Server 2016 or 2017 Q4040519 KB4040519 January 14, 2021
• 4040512 FIX: Error when exporting a Reporting Services report to PDF in SQL Server 2016 or 2017 Q4040512 KB4040512 January 14, 2021
• 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server Q4040401 KB4040401 January 14, 2021
• 4040376 FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server Q4040376 KB4040376 January 14, 2021
• 4040108 FIX: Backup of availability database via VSS-based application may fail in SQL Server Q4040108 KB4040108 January 14, 2021
• 4040085 FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 or 2017 Q4040085 KB4040085 January 14, 2021
• 4039868 FIX: Performance drop when using In-Memory OLTP with Always On availability groups in SQL Server 2016 or 2017 Q4039868 KB4039868 January 14, 2021
• 4039126 FIX: Horizontal scroll bar missing from Subscription page in SSRS 2016 or 2017 web portal Q4039126 KB4039126 January 14, 2021
• 4039125 FIX: "The folder ... does not exist" error when deleting a folder in web portal of SQL Server 2016 or 2017 Reporting Service Q4039125 KB4039125 January 14, 2021
• 4035062 FIX: Memory use with many databases greater in SQL Server 2016 than earlier versions Q4035062 KB4035062 January 14, 2021
• 4024860 Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 or 2017 Q4024860 KB4024860 January 14, 2021
• 4010460 FIX: .NET Framework error when you update the reference table of a Fuzzy Lookup transformation in SSIS Q4010460 KB4010460 January 14, 2021
• 955784 Can't use the Setup program to modify the failover cluster instance in SSAS Q955784 KB955784 January 14, 2021
• 4594205 "Attempted to perform an unauthorized operation" error when you set up or update SQL Server instances Q4594205 KB4594205 January 13, 2021