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.

• 4589350 FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server Q4589350 KB4589350 February 25, 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
• 5001045 FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 Q5001045 KB5001045 February 24, 2021
• 5001044 FIX: Wrong results occur when you run a query on In-memory optimized tables in SQL Server 2017 Q5001044 KB5001044 February 24, 2021
• 5000685 Cumulative Update 23 for SQL Server 2017 Q5000685 KB5000685 February 24, 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
• 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 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
• 4585971 FIX: User session is in rollback state indefinitely after it is killed in SQL Server Q4585971 KB4585971 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
• 4568447 FIX: Automatic seeding failure occurs for a secondary replica in SQL Server Q4568447 KB4568447 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
• 4486936 FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server 2016 and 2017 Q4486936 KB4486936 February 24, 2021
• 4047329 SQL Server 2017 build versions Q4047329 KB4047329 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
• 4484710 Cumulative Update 14 for SQL Server 2017 Q4484710 KB4484710 February 12, 2021
• 4466404 Cumulative Update 13 for SQL Server 2017 Q4466404 KB4466404 February 12, 2021
• 4464082 Cumulative Update 12 for SQL Server 2017 Q4464082 KB4464082 February 12, 2021
• 4462262 Cumulative Update 11 for SQL Server 2017 Q4462262 KB4462262 February 12, 2021
• 4342123 Cumulative Update 10 for SQL Server 2017 Q4342123 KB4342123 February 12, 2021
• 4341265 Cumulative Update 9 for SQL Server 2017 Q4341265 KB4341265 February 12, 2021
• 4338363 Cumulative Update 8 for SQL Server 2017 Q4338363 KB4338363 February 12, 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
• 4092997 VC++ 2015 Redistributable installation returns error 1638 when newer version already installed Q4092997 KB4092997 February 11, 2021
• 4497928 FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 Q4497928 KB4497928 February 9, 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
• 4577467 Cumulative Update 22 for SQL Server 2017 Q4577467 KB4577467 January 26, 2021
• 4557397 Cumulative Update 21 for SQL Server 2017 Q4557397 KB4557397 January 26, 2021
• 4541283 Cumulative Update 20 for SQL Server 2017 Q4541283 KB4541283 January 26, 2021
• 4535007 Cumulative Update 19 for SQL Server 2017 Q4535007 KB4535007 January 26, 2021
• 4527377 Cumulative Update 18 for SQL Server 2017 Q4527377 KB4527377 January 26, 2021
• 4515579 Cumulative Update 17 for SQL Server 2017 Q4515579 KB4515579 January 26, 2021
• 4508218 Cumulative Update 16 for SQL Server 2017 Q4508218 KB4508218 January 26, 2021
• 4498951 Cumulative Update 15 for SQL Server 2017 Q4498951 KB4498951 January 26, 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
• 4470057 FIX: Error 41168 occurs when you try to alter DAG SEEDING_MODE in SQL Server 2016 and 2017 Q4470057 KB4470057 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
• 4460203 FIX: Pacemaker may kill the resource agent processes when operation times out in SQL Server 2017 AlwaysOn Availability Group Q4460203 KB4460203 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
• 4340730 FIX: Assertion error occurs when a query that uses a linked server is cancelled in SQL Server 2016 and 2017 Q4340730 KB4340730 January 26, 2021
• 4338960 FIX: "PAGE_FAULT_IN_NONPAGED_AREA" Stop error when enumerating contents in a SQL Server FileTable directory Q4338960 KB4338960 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
• 4229789 Cumulative Update 7 for SQL Server 2017 Q4229789 KB4229789 January 26, 2021
• 4131496 Improvement: Enable "forced flush" mechanism in SQL Server 2017 on Linux Q4131496 KB4131496 January 26, 2021
• 4101464 Cumulative Update 6 for SQL Server 2017 Q4101464 KB4101464 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
• 4092643 Cumulative Update 5 for SQL Server 2017 Q4092643 KB4092643 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
• 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
• 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
• 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
• 4056498 Cumulative Update 4 for SQL Server 2017 Q4056498 KB4056498 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
• 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
• 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
• 4052987 Cumulative Update 3 for SQL Server 2017 Q4052987 KB4052987 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
• 4052574 Cumulative Update 2 for SQL Server 2017 Q4052574 KB4052574 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
• 4046056 FIX: Assertion occurs when you access memory-optimized table through MARS in SQL Server 2016 and 2017 Q4046056 KB4046056 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
• 4039592 FIX: Cannot change the password for a SQL Server service account when additional LSA protection is enabled Q4039592 KB4039592 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
• 4038634 Cumulative Update 1 for SQL Server 2017 Q4038634 KB4038634 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
• 957826 Where to find information about the latest SQL Server builds Q957826 KB957826 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
• 4583468 Microsoft SQL Server elevation of privilege vulnerability Q4583468 KB4583468 January 14, 2021
• 4583457 Description of the security update for SQL Server 2017 CU22: January 12, 2021 Q4583457 KB4583457 January 14, 2021
• 4583456 Description of the security update for SQL Server 2017 GDR: January 12, 2021 Q4583456 KB4583456 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
• 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 13, 2021
• 4532432 Mssql-conf tool fails if IPV6 is disabled on the Linux system Q4532432 KB4532432 January 13, 2021
• 955784 Can't use the Setup program to modify the failover cluster instance in SSAS Q955784 KB955784 January 13, 2021
• 4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016 and 2017 Q4466994 KB4466994 January 12, 2021