SQL Server 2016 articles, fixes and updates - January 2021

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

• 5852300 FIX: SQL Server 2014 or 2016 crashes on the execution of the DBCC CLONEDATABASE command Q5852300 KB5852300 January 26, 2021
• 4564903 Cumulative Update 14 for SQL Server 2016 SP2 Q4564903 KB4564903 January 26, 2021
• 4536648 Cumulative Update 12 for SQL Server 2016 SP2 Q4536648 KB4536648 January 26, 2021
• 4527378 Cumulative Update 11 for SQL Server 2016 SP2 Q4527378 KB4527378 January 26, 2021
• 4524334 Cumulative Update 10 for SQL Server 2016 SP2 Q4524334 KB4524334 January 26, 2021
• 4505830 Cumulative Update 8 for SQL Server 2016 SP2 Q4505830 KB4505830 January 26, 2021
• 4495256 Cumulative Update 7 for SQL Server 2016 SP2 Q4495256 KB4495256 January 26, 2021
• 4488536 Cumulative Update 6 for SQL Server 2016 SP2 Q4488536 KB4488536 January 26, 2021
• 4488535 Cumulative Update 14 for SQL Server 2016 SP1 Q4488535 KB4488535 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
• 4476977 FIX: Error 5901 occurs on the same offset in SQL Server 2016 until server is restarted Q4476977 KB4476977 January 26, 2021
• 4476949 FIX: Database Mail cannot send emails after you install CU1, CU2 or CU3 for SQL Server 2016 Service Pack 2 Q4476949 KB4476949 January 26, 2021
• 4475794 FIX: Access violation exception occurs during Query Optimization of a query that accesses a table with Filtered Indexes or Statistics Q4475794 KB4475794 January 26, 2021
• 4475775 Cumulative Update 13 for SQL Server 2016 SP1 Q4475775 KB4475775 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
• 4470916 FIX: Out of memory error occurs when Database Node Memory (KB) drops below 2 percent in SQL Server 2014 and 2016 Q4470916 KB4470916 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
• 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
• 4464343 Cumulative Update 12 for SQL Server 2016 SP1 Q4464343 KB4464343 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
• 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
• 4459545 FIX: Upgrading SP1 instance fails when you use SxS instances of SQL Server 2016 SP1 and SP2 Q4459545 KB4459545 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
• 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
• 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
• 4340759 FIX: Slow performance of SQL Server 2016 when Query Store is enabled Q4340759 KB4340759 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
• 4339447 FIX: SSAS crashes when Process Full mode is executed after Process Clear in SQL Server 2016 Q4339447 KB4339447 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
• 4338040 FIX: Rectangle does not grow vertically together with internal Textbox in the report in SSRS 2016 when you set rc:Toolbar=False Q4338040 KB4338040 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
• 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
• 4092069 Improves the Distribution Agent cleanup procedure to increase the transactional replication performance in SQL Server 2016 Q4092069 KB4092069 January 26, 2021
• 4092045 FIX: LSN truncation occurs in AlwaysOn AG when disabling the change data capture feature in SQL Server 2016 Q4092045 KB4092045 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
• 4090966 SQL Server session hangs when you try to enable snapshot isolation in SQL Server 2016 Q4090966 KB4090966 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
• 4090279 FIX: It takes a long time to roll back a batch that updates a large amount of data in SQL Server 2016 Q4090279 KB4090279 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
• 4087358 FIX: Expression-based connection string is cleared out when you configure data sources for the report in SSRS 2016 Q4087358 KB4087358 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
• 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
• 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
• 4057212 FIX: Memory leak occurs when you back up a database that contains memory-optimized objects in SQL Server 2016 Q4057212 KB4057212 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
• 4057119 Cumulative Update 7 for SQL Server 2016 SP1 Q4057119 KB4057119 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
• 4056831 FIX: Error 27231 occurs when SSIS package that contains localized language is deployed in SQL Server 2016 Q4056831 KB4056831 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
• 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
• 4056008 FIX: "sp_special_columns" returns incorrect result in SQL Server 2014 and 2016 Q4056008 KB4056008 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
• 4055556 FIX: Error when you rebuild a single partition of an index online in SQL Server 2014 and 2016 Q4055556 KB4055556 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
• 4053550 FIX: Processing XML message through Service Broker results in hung session in SQL Server 2016 and 2017 Q4053550 KB4053550 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
• 4052138 FIX: Parallel queries are slower when they are run with high DOP in SQL Server 2016 Q4052138 KB4052138 January 26, 2021
• 4052137 Improve query performance on a partitioned table in SQL Server 2016 SP2 Q4052137 KB4052137 January 26, 2021
• 4052136 FIX: SQL Server Audit Events fail to write to the Security log Q4052136 KB4052136 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
• 4052125 FIX: Audit Log for ROLLBACK TRANSACTION event is not available in SQL Server 2016 Q4052125 KB4052125 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
• 4052119 FIX: New Distributed Transactions in an AG database fails after you restart DTC service in SQL Server 2016 Q4052119 KB4052119 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
• 4051360 FIX: Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2 Q4051360 KB4051360 January 26, 2021
• 4051358 Update adds new columns to sys.dm_exec_query_stats DMV in SQL Server 2016 SP2 Q4051358 KB4051358 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
• 4046909 FIX: LogPool cache MEMORYCLERK_SQLLOGPOOL consumes more memory when you do online transactions in SQL Server 2016 SP1 Express Edition Q4046909 KB4046909 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
• 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
• 4042788 FIX: The tempdb system database is still encrypted after you turn off encryption on an instance of SQL Server Q4042788 KB4042788 January 26, 2021
• 4042415 FIX: Deadlock occurs on single-user mode database when many connections access it simultaneously in SQL Server 2014 and 2016 Q4042415 KB4042415 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
• 4040714 Cumulative Update 5 for SQL Server 2016 SP1 Q4040714 KB4040714 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
• 4040510 FIX: A dump file is generated when you run a sp_execute_external_script statement in parallel mode in SQL Server 2016 Q4040510 KB4040510 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
• 4038418 Update adds a new column to DMV sys.dm_sql_referenced_entities in SQL Server 2014 and 2016 Q4038418 KB4038418 January 26, 2021
• 4038210 FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed Q4038210 KB4038210 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
• 4037435 FIX: Access violation occurs when you query the sys.availability_groups catalog view in SQL Server 2016 Q4037435 KB4037435 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
• 4037357 Cumulative Update 9 for SQL Server 2016 Q4037357 KB4037357 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
• 4034056 FIX: Access violation occurs when you run a query in SQL Server 2016 Q4034056 KB4034056 January 26, 2021
• 4033789 FIX: A memory leak may occur when you perform Process Update operations in SSAS Q4033789 KB4033789 January 26, 2021
• 4033178 FIX: Cast error when you open a local mode report in SharePoint Integrated mode in SSRS 2016 Q4033178 KB4033178 January 26, 2021
• 4032686 FIX: Search result isn't highlighted in SSRS 2016 report in SharePoint integrated mode Q4032686 KB4032686 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
• 4032200 FIX: Fail to compress the backup file when INIT and COMPRESSION option is used in a TDE enabled database in SQL Server 2016 Q4032200 KB4032200 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
• 4025261 FIX: The setting for deadlock priority doesn't work when you run the ALTER PARTITION FUNCTION statement in SQL Server 2016 Q4025261 KB4025261 January 26, 2021
• 4025208 FIX: Memory leak occurs when you use memory-optimized tables in Microsoft SQL Server 2016 Standard edition Q4025208 KB4025208 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
• 4024715 FIX: SharePoint sites that contain the Report Viewer Web Part fail to load after you upgrade from SharePoint 2013 to 2016 in SSRS 2016 Q4024715 KB4024715 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
• 4024548 FIX: It takes a long time to perform lots of write operations on SSAS databases in SQL Server 2016 Q4024548 KB4024548 January 26, 2021
• 4024449 FIX: Databases on secondary replica show "NOT SYNCHRONIZING" status after failover in SQL Server 2016 Q4024449 KB4024449 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
• 4024311 FIX: "Non-yielding Scheduler" condition occurs on spinlock contention in Microsoft SQL Server 2014 or 2016 Q4024311 KB4024311 January 26, 2021
• 4024304 Cumulative Update 7 for SQL Server 2016 Q4024304 KB4024304 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
• 4023419 FIX: Query with UNION ALL and a row goal may run slower in SQL Server 2014 or later versions when it's compared to SQL Server 2008 R2 Q4023419 KB4023419 January 26, 2021
• 4022935 FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014 or 2016 Q4022935 KB4022935 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
• 4022873 FIX: "FILESTREAM feature is disabled" error when you use the FILESTREAM feature for SQL Server 2014 or 2016 in Windows 10 Creators Update Q4022873 KB4022873 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
• 4021580 Fix: System generated stored procedures are created incorrectly in P2P publication if the schema name of published table contains a period (.) in SQL Server 2014 or 2016 Q4021580 KB4021580 January 26, 2021
• 4021243 FIX: Access violation when you create or configure an Always On availability group for an availability database in SQL Server 2012 and 2016 Q4021243 KB4021243 January 26, 2021
• 4019917 Improvement: Improves the performance in opening a mobile report that contains a large dataset in SSRS 2016 Q4019917 KB4019917 January 26, 2021
• 4019916 Cumulative Update 3 for SQL Server 2016 SP1 Q4019916 KB4019916 January 26, 2021
• 4019914 Cumulative Update 6 for SQL Server 2016 Q4019914 KB4019914 January 26, 2021
• 4019903 FIX: Query against sys.dm_db_partition_stats DMV runs slow if the database contains large numbers of columnstore partitions in SQL Server 2016 Q4019903 KB4019903 January 26, 2021
• 4019893 FIX: Restore fails when you do backup by using compression and checksum on a TDE enabled database in SQL Server 2016 Q4019893 KB4019893 January 26, 2021
• 4019840 FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2016 and 2017 Q4019840 KB4019840 January 26, 2021
• 4019803 FIX: KPIs appear in a random order when you add KPIs to the Favorites page in SSRS 2016 web portal Q4019803 KB4019803 January 26, 2021
• 4019799 FIX: Deadlock when run the "CleanOrphanedPolicies" and "DeleteDataSources" built-in stored procedures together in SSRS 2016 Q4019799 KB4019799 January 26, 2021
• 4019718 FIX: Intra-query deadlock when you execute a parallel query that contains outer join operators in SQL Server 2016 Q4019718 KB4019718 January 26, 2021
• 4019511 FIX: SSAS 2016 fails to start if the MemoryHeapType and HeapTypeForObjects properties are set to "-1" Q4019511 KB4019511 January 26, 2021
• 4019445 FIX: Pie chart legend doesn't format percentage values properly in a SSRS 2016 mobile report Q4019445 KB4019445 January 26, 2021
• 4019285 FIX: Error when you execute DBCC CLONEDATABASE on an "Always Encrypted" enabled database in SQL Server 2014 or 2016 Q4019285 KB4019285 January 26, 2021
• 4019028 FIX: SQL Server 2016 consumes more memory when you reorganize a columnstore index Q4019028 KB4019028 January 26, 2021
• 4018955 FIX: Error when you process a calculated column on a database with compatibility level 1200 in SSAS 2016 tabular mode Q4018955 KB4018955 January 26, 2021
• 4018954 FIX: Domain entity drop-down displays an incorrect value when you connect to MDS by using MDS Add-in for Excel in SQL Server 2016 Q4018954 KB4018954 January 26, 2021
• 4018930 Update adds the "CLR strict security" feature to SQL Server Q4018930 KB4018930 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
• 4018882 FIX: Mobile report does not display correct formatting when regional setting is set to Non-English in SSRS 2016 Q4018882 KB4018882 January 26, 2021
• 4018866 FIX: Parallel redo causes high memory usage in SQL Server 2016 when it's compared to SQL Server 2014 or earlier versions Q4018866 KB4018866 January 26, 2021
• 4017737 FIX: MDS entity sync fails if the Name or Code attribute contains non-default values in SQL Server 2016 Q4017737 KB4017737 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
• 4017080 FIX: Transaction log backup failure on the secondary replica in SQL Server 2012 Always-On Availability Groups Q4017080 KB4017080 January 26, 2021
• 4017023 SQL Server 2012, 2014 or 2016 Backup to Microsoft Azure Blob storage service URL isn't compatible for TLS 1.2 Q4017023 KB4017023 January 26, 2021
• 4016949 Unified Showplan Schema for different versions of SQL Server Q4016949 KB4016949 January 26, 2021
• 4016946 FIX: Deadlock when you use sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats DMV with large DDL operations in SQL Server 2016 Q4016946 KB4016946 January 26, 2021
• 4016945 FIX: "The custom resolver for this article requires OLEAUT32.DLL with a minimum version of 2.40.4276" error with merge publication in SQL Server Q4016945 KB4016945 January 26, 2021
• 4016902 FIX: Access violation when you use SELECT TOP query to retrieve data from clustered columnstore index in SQL Server 2016 Q4016902 KB4016902 January 26, 2021
• 4016361 FIX: Service Broker endpoint connections aren't closed after an availability group failover in SQL Server Q4016361 KB4016361 January 26, 2021
• 4015561 FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server Q4015561 KB4015561 January 26, 2021
• 4015093 FIX: "rsUnknownReportParameter" error when you click a report from search results in SSRS 2016 Q4015093 KB4015093 January 26, 2021
• 4015034 FIX: An assertion occurs when you run an UPDATE statement on a clustered columnstore index in SQL Server 2016 Q4015034 KB4015034 January 26, 2021
• 4014862 FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2014 or 2016 Q4014862 KB4014862 January 26, 2021
• 4014756 FIX: SQL Server Profiler fails to obfuscate sp_setapprole when it's executed from a remote procedure call in SQL Server Q4014756 KB4014756 January 26, 2021
• 4014738 FIX: Error occurs when you drop a subscription by using a non-sysadmin account in SQL Server Q4014738 KB4014738 January 26, 2021
• 4014734 FIX: SQL Server Launchpad service fails to start if the installed version of R Services (In-Database) is different from the Database Engine in SQL Server 2016 Q4014734 KB4014734 January 26, 2021
• 4014732 FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server Q4014732 KB4014732 January 26, 2021
• 4014002 Improvement: Enables SQL Server Managed Backup to back up databases that are larger than 50 GB to Microsoft Azure in SQL Server 2016 Q4014002 KB4014002 January 26, 2021
• 4013936 FIX: Hadoop File System Task fails after 10 minutes when you open and run a saved SSIS 2016 package Q4013936 KB4013936 January 26, 2021
• 4013883 FIX: Data type conversion error due to late evaluation of a filter predicate in a query involving a column store index in SQL Server 2016 Q4013883 KB4013883 January 26, 2021
• 4013851 FIX: Error when you add a NOT NULL column with default values to a non-empty clustered columnstore index in SQL Server 2016 Standard and Express edition Q4013851 KB4013851 January 26, 2021
• 4013248 FIX: User authentication failure in SSRS 2016 due to Report Server Web Service URL truncation under Custom Security Extensions deployment Q4013248 KB4013248 January 26, 2021
• 4013247 FIX: SSRS subscriptions fail to run for a report that connects to a SharePoint External list Q4013247 KB4013247 January 26, 2021
• 4013208 FIX: "Partition cannot contain column segments of different data versions" error when you process data on a partition in SSAS Tabular model Q4013208 KB4013208 January 26, 2021
• 4013128 FIX: Decreased performance and long waits for CLR_AUTO_EVENT and CMEMTHREAD when SQLCLR UDT is used as a stored procedure parameter for a SQL RPC call Q4013128 KB4013128 January 26, 2021
• 4013122 Improvement: Performance improvement for "sequence point algorithm" step in SSAS 2016 Tabular Model transactions Q4013122 KB4013122 January 26, 2021
• 4013120 Improvement: Enable DBCC CLONEDATABASE to clone a full-text object in SQL Server 2016 SP1 Q4013120 KB4013120 January 26, 2021
• 4013106 Cumulative Update 2 for SQL Server 2016 SP1 Q4013106 KB4013106 January 26, 2021
• 4010984 FIX: Assertion error when dm_exec_query_statistics_xml is used in a query plan that contains certain operators in SQL Server 2016 Q4010984 KB4010984 January 26, 2021
• 4010344 FIX: The sp_msx_enlist stored procedure fails to enlist a target server into a master server in SQL Server 2014 or 2016 if the server name is too long Q4010344 KB4010344 January 26, 2021
• 4009839 FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode Q4009839 KB4009839 January 26, 2021
• 4009794 FIX: Internal Error "FAC_HK_INTERNAL" when you insert or update large number of rows of data into or in a memory-optimized table in SQL Server 2016 Q4009794 KB4009794 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
• 3213709 FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services Q3213709 KB3213709 January 26, 2021
• 3213703 FIX: An Always On secondary replica goes into a disconnecting state Q3213703 KB3213703 January 26, 2021
• 3213683 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2014 or 2016 Q3213683 KB3213683 January 26, 2021
• 3213524 FIX: Text box is missing when the toggle action is enabled in SSRS 2016 Q3213524 KB3213524 January 26, 2021
• 3213291 FIX: Kernel crash when you create a database after you drop a database that contains FILESTEAM data in SQL Server 2016 Q3213291 KB3213291 January 26, 2021
• 3213288 FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group Q3213288 KB3213288 January 26, 2021
• 3213283 FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016 Q3213283 KB3213283 January 26, 2021
• 3213263 FIX: Error when creating a stored procedure that uses a synonym together with an index hint in SQL Server 2016 Q3213263 KB3213263 January 26, 2021
• 3213240 FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption Q3213240 KB3213240 January 26, 2021
• 3212916 FIX: SSAS may crash on query execution if a predefined role is specified in the connection string Q3212916 KB3212916 January 26, 2021
• 3212789 FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016 Q3212789 KB3212789 January 26, 2021
• 3212723 FIX: A query that contains a hint against a view that references at least one temporal table in a different database generates a dump file in SQL Server 2016 Q3212723 KB3212723 January 26, 2021
• 3212523 FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory Q3212523 KB3212523 January 26, 2021
• 3212482 FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016 Q3212482 KB3212482 January 26, 2021
• 3212227 FIX: You can't run a data cleanse against a view in SQL Server 2016 Data Quality Services Q3212227 KB3212227 January 26, 2021
• 3212214 FIX: Cannot execute the DBCC CLONEDATABASE command on an instance of SQL Server 2014 or 2016 after an in-place upgrade Q3212214 KB3212214 January 26, 2021
• 3211991 FIX: SQL Server 2016 Reporting Services mobile reports can't be rendered in your browser through Active Directory Application Proxy Q3211991 KB3211991 January 26, 2021
• 3211948 FIX: "Adjust height to fit zone" setting of the SSRS 2016 Report Viewer Web Part isn't respected on a SharePoint webpage Q3211948 KB3211948 January 26, 2021
• 3211646 FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016 Q3211646 KB3211646 January 26, 2021
• 3211605 FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode Q3211605 KB3211605 January 26, 2021
• 3211602 FIX: Cannot insert data into a table that uses a clustered columnstore index in SQL Server 2016 Q3211602 KB3211602 January 26, 2021
• 3211338 FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016 Q3211338 KB3211338 January 26, 2021
• 3211304 FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica in SQL Server 2012, 2014 or 2016 Q3211304 KB3211304 January 26, 2021
• 3210747 FIX: The “sys.dm_db_column_store_row_group_physical_stats” query runs slowly on SQL Server 2016 Q3210747 KB3210747 January 26, 2021
• 3210708 FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates Q3210708 KB3210708 January 26, 2021
• 3210699 FIX: Errors are logged if database mirroring is configured by Transact-SQL in SQL Server 2016 Q3210699 KB3210699 January 26, 2021
• 3210597 FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016 Q3210597 KB3210597 January 26, 2021
• 3210395 FIX: A dump file is generated when you enable system-versioning on a table in SQL Server 2016 Q3210395 KB3210395 January 26, 2021
• 3210111 GDR update package for SQL Server 2016 RTM Q3210111 KB3210111 January 26, 2021
• 3210110 On-demand hotfix update package for SQL Server 2016 CU3 Q3210110 KB3210110 January 26, 2021
• 3210089 GDR update package for SQL Server 2016 SP1 Q3210089 KB3210089 January 26, 2021
• 3210087 FIX: Errors when you try to save MDS business rules in SQL Server 2016 Q3210087 KB3210087 January 26, 2021
• 3209896 Can't change PolyBase service accounts without reinstalling the PolyBase feature in SQL Server 2016 Q3209896 KB3209896 January 26, 2021
• 3209878 FIX: SQL Server runs out of memory when you query data from memory-optimized tables if Resource Governor is enabled Q3209878 KB3209878 January 26, 2021
• 3209520 FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly Q3209520 KB3209520 January 26, 2021
• 3209459 FIX: Error 21050 when you remove a table that is not part of a publication in SQL Server 2014 or 2016 Q3209459 KB3209459 January 26, 2021
• 3209443 Update improves the stability of SQL Server Management Studio when exiting or removing a connection from Object Explorer Q3209443 KB3209443 January 26, 2021
• 3209442 FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server MDM report Q3209442 KB3209442 January 26, 2021
• 3209426 FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state Q3209426 KB3209426 January 26, 2021
• 3208545 FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation Q3208545 KB3208545 January 26, 2021
• 3208524 FIX: You cannot select any replica when you fail over from an availability group that's in the resolving state Q3208524 KB3208524 January 26, 2021
• 3208484 "Only secure content is displayed" warning when you open a SQL Server 2016 SP1 Reporting Services report or web portal Q3208484 KB3208484 January 26, 2021
• 3208483 You cannot print in Reporting Services reports after you install SQL Server 2016 SP1 Q3208483 KB3208483 January 26, 2021
• 3208460 FIX: DMV sys.dm_os_spinlock_stats returns incorrect results after you install SQL Server 2016 CU5 Q3208460 KB3208460 January 26, 2021
• 3208326 FIX: Can't take ownership of an availability group after the owner is dropped in SQL Server 2014 or 2016 Q3208326 KB3208326 January 26, 2021
• 3208276 Update improves handling of documents too large for Full-Text Search indexing in SQL Server Q3208276 KB3208276 January 26, 2021
• 3208246 Updates to DBCC CLONEDATABASE functionality in SQL Server 2014 and 2016 Q3208246 KB3208246 January 26, 2021
• 3208245 FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 or 2016 Q3208245 KB3208245 January 26, 2021
• 3208243 FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016 Q3208243 KB3208243 January 26, 2021
• 3208179 FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services Q3208179 KB3208179 January 26, 2021
• 3208178 FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services Q3208178 KB3208178 January 26, 2021
• 3207512 Important update for SQL Server 2016 SP1 Reporting Services Q3207512 KB3207512 January 26, 2021
• 3207327 FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server Q3207327 KB3207327 January 26, 2021
• 3206584 FIX: Checkpoint files grow excessively when you insert data into memory-optimized tables in SQL Server 2016 Q3206584 KB3206584 January 26, 2021
• 3206401 FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016 Q3206401 KB3206401 January 26, 2021
• 3206299 FIX: Availability databases in incorrect initializing/synchronizing state after failover of SQL Server 2014 or 2016 Always On availability group Q3206299 KB3206299 January 26, 2021
• 3205994 FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016 Q3205994 KB3205994 January 26, 2021
• 3205964 FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016 Q3205964 KB3205964 January 26, 2021
• 3205935 FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014 or 2016 Q3205935 KB3205935 January 26, 2021
• 3205411 FIX: "Non-yielding Scheduler" condition when you parallel-load data into a columnstore index in SQL Server 2016 Q3205411 KB3205411 January 26, 2021
• 3204804 Improvement: New sys.dm_db_stats_histogram Dynamic Management View is available in SQL Server 2016 SP1 CU2 Q3204804 KB3204804 January 26, 2021
• 3204769 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 or 2016 Q3204769 KB3204769 January 26, 2021
• 3204469 FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication Q3204469 KB3204469 January 26, 2021
• 3204265 FIX: Image maps not rendered as expected in SSRS custom report item Q3204265 KB3204265 January 26, 2021
• 3202425 Improvement: Improves the query performance for SQL Server 2016 by changing the use of histograms on UNIQUE columns Q3202425 KB3202425 January 26, 2021
• 3201865 FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server Q3201865 KB3201865 January 26, 2021
• 3201554 FIX: Long compilation time for a query that contains many distinct operators in SQL Server 2016 Q3201554 KB3201554 January 26, 2021
• 3201552 Update adds overall query execution statistics information to the STATISTICS XML output in SQL Server 2012, 2014 and 2016 Q3201552 KB3201552 January 26, 2021
• 3201416 FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 or 2016 Q3201416 KB3201416 January 26, 2021
• 3200975 FIX: Assertion occurs when you use parallel redo in a secondary replica of a SQL Server AlwaysOn Availability Group Q3200975 KB3200975 January 26, 2021
• 3199177 Master Data Management (MDM) Support for Microsoft SQL Server 2016 Q3199177 KB3199177 January 26, 2021
• 3199171 On-demand hotfix update package for SQL Server 2016 CU2 Q3199171 KB3199171 January 26, 2021
• 3198827 FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members Q3198827 KB3198827 January 26, 2021
• 3198826 FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services Q3198826 KB3198826 January 26, 2021
• 3198766 FIX: Error 19432 after you upgrade Availability replicas in an Always On Availability Group to CU1 for SQL Server 2016 Q3198766 KB3198766 January 26, 2021
• 3198760 FIX: Error 19432 and time-out errors with SQL Server 2016 AlwaysOn Availability Groups Q3198760 KB3198760 January 26, 2021
• 3198356 FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services Q3198356 KB3198356 January 26, 2021
• 3198285 FIX: Parallel insert operation into a temp table causes SQL Server 2016 to freeze Q3198285 KB3198285 January 26, 2021
• 3198261 FIX: MDS business rule doesn't work if the Code value contains a leading space in SQL Server MDS Add-in for Excel Q3198261 KB3198261 January 26, 2021
• 3197952 FIX: Performance regression in the expression service during numeric arithmetic operations in SQL Server 2016 Q3197952 KB3197952 January 26, 2021
• 3197893 FIX: Rolling upgrade for AlwaysOn replica fails after Cumulative Update 1 for SQL Server 2016 is installed Q3197893 KB3197893 January 26, 2021
• 3197883 FIX: Snapshot Agent fails when you publish UDF’s to SQL Server 2016 Distributor in Transactional Replication Q3197883 KB3197883 January 26, 2021
• 3197879 FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent Q3197879 KB3197879 January 26, 2021
• 3197758 FIX: Time-out error when you process multiple partitions in parallel in SQL Server 2016 Analysis Services (Tabular model) Q3197758 KB3197758 January 26, 2021
• 3197631 FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server Q3197631 KB3197631 January 26, 2021
• 3197605 FIX: SQL Server 2016 hangs when you restore databases that contain memory-optimized tables Q3197605 KB3197605 January 26, 2021
• 3197589 FIX: Heap scan may cause high PAGEIOLATCH_SH waits in SQL Server 2016 Q3197589 KB3197589 January 26, 2021
• 3197403 FIX: SQL Server 2016 Reporting Services keeps cycling to unload application domains when Report Server is configured on a Network Load Balancing Cluster Q3197403 KB3197403 January 26, 2021
• 3196877 FIX: Incremental statistics runs with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014 or 2016 Q3196877 KB3196877 January 26, 2021
• 3196450 FIX: The plaintext password is exposed in the connection string in SQL Server 2016 Analysis Services Q3196450 KB3196450 January 26, 2021
• 3196102 FIX: Performance issues caused by continuous growth of memory in SQL Server 2016 Analysis Services Q3196102 KB3196102 January 26, 2021
• 3196100 FIX: Exception occurs during parallel processing of partitions if a column is re-encoded in SQL Server 2016 Q3196100 KB3196100 January 26, 2021
• 3196012 FIX: Incorrect full-text keys are recorded for the rows that aren't indexed correctly by a full-text index in SQL Server Q3196012 KB3196012 January 26, 2021
• 3195901 FIX: SQL Server 2016 crashes when a Tuple Mover task is ended unexpectedly Q3195901 KB3195901 January 26, 2021
• 3195825 FIX: Deadlock when you execute a query plan with a nested loop join in batch mode in SQL Server 2014 or 2016 Q3195825 KB3195825 January 26, 2021
• 3195813 On-demand hotfix update package for SQL Server 2016 CU2 Q3195813 KB3195813 January 26, 2021
• 3194959 Statistics are removed after rebuilding a specific partition of an partitioned aligned index on a partitioned table in SQL Server Q3194959 KB3194959 January 26, 2021
• 3194365 FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking Q3194365 KB3194365 January 26, 2021
• 3192738 SQL Server 2016 installer updates Q3192738 KB3192738 January 26, 2021
• 3192692 FIX: Assert memory dump on a mirror server in SQL Server Q3192692 KB3192692 January 26, 2021
• 3192636 Data grid becomes blank when you scroll if the "Row numbers" option is set to Hide in a SQL Server 2016 Reporting Services mobile report Q3192636 KB3192636 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
• 3192117 Access violation when you run a query if trace flag 4139 is enabled in SQL Server 2016 Q3192117 KB3192117 January 26, 2021
• 3191515 Incorrect mobile report filtering when the parameter contains special characters in SQL Server 2016 Reporting Services Q3191515 KB3191515 January 26, 2021
• 3191273 Update adds support for self-referential constraints in the new Referential Integrity Operator in SQL Server 2016 Q3191273 KB3191273 January 26, 2021
• 3191062 FIX: FileTable directory stops responding when you create multiple files concurrently in SQL Server 2014 or 2016 Q3191062 KB3191062 January 26, 2021
• 3190871 New sys.dm_exec_query_statistics_xml Dynamic Management Function is available in SQL Server 2016 SP1 Q3190871 KB3190871 January 26, 2021
• 3190762 Update to improve diagnostics for query execution plans that involve residual predicate pushdown in SQL Server 2016 Q3190762 KB3190762 January 26, 2021
• 3190761 Update to improve diagnostics by expose data type of the parameters for parameterized queries in showplan XML output in SQL Server 2016 Q3190761 KB3190761 January 26, 2021
• 3190548 Update introduces CREATE OR ALTER Transact-SQL statement in SQL Server 2016 Q3190548 KB3190548 January 26, 2021
• 3189959 FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment Q3189959 KB3189959 January 26, 2021
• 3189855 FIX: Intermittent non-yielding conditions, performance problems and intermittent connectivity failures in SQL Server 2016 Q3189855 KB3189855 January 26, 2021
• 3189813 Update introduces USE HINT query hint argument in SQL Server 2016 Q3189813 KB3189813 January 26, 2021
• 3189709 FIX: Installation of Cumulative Update 1 for SQL Server 2016 fails on a named instance Q3189709 KB3189709 January 26, 2021
• 3189687 FIX: "'Salt' attribute for Password is missing in the project manifest" error in SQL Server Q3189687 KB3189687 January 26, 2021
• 3189663 FIX: SQL Server error log incorrectly cites logical processors when soft-NUMA is enabled Q3189663 KB3189663 January 26, 2021
• 3189655 Error 33294 if a cursor is declared by using the OPTION (RECOMPILE) query hint in SQL Server 2016 Q3189655 KB3189655 January 26, 2021
• 3189372 Query returns incorrect results from nonclustered columnstore index under snapshot isolation level in SQL Server 2016 Q3189372 KB3189372 January 26, 2021
• 3189364 Query Store returns unusual characters when a JOIN operator is used in SQL Server 2016 Q3189364 KB3189364 January 26, 2021
• 3189264 Incorrect results are returned when you run a query that contains a GROUP BY operation in SQL Server 2016 Q3189264 KB3189264 January 26, 2021
• 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server Q3189229 KB3189229 January 26, 2021
• 3189060 Standard edition of SQL Server 2016 Analysis Services (Tabular mode) ignores the 16 GB memory limit Q3189060 KB3189060 January 26, 2021
• 3188978 FIX: "Cannot bulk load" error when you run a query that contains an UPDATE statement in SQL Server 2016 Q3188978 KB3188978 January 26, 2021
• 3188950 Updating while compression is in progress can lead to nonclustered columnstore index corruption in SQL Server 2016 Q3188950 KB3188950 January 26, 2021
• 3188454 Improvement: Enhance VDI Protocol with VDC_Complete command in SQL Server Q3188454 KB3188454 January 26, 2021
• 3188368 FIX: Access violation on secondary replica when there are too many parallel redo operations in SQL Server 2016 Q3188368 KB3188368 January 26, 2021
• 3188160 FIX: Can't add new explicit hierarchies after deleting existing explicit hierarchies from an entity in SQL Server 2016 Master Data Services Q3188160 KB3188160 January 26, 2021
• 3188158 FIX: Filter and Change Tracking settings are removed after you change a domain-based attribute in SQL Server 2016 Master Data Services Q3188158 KB3188158 January 26, 2021
• 3188157 Functional area permissions are lost after you upgrade to SQL Server 2016 Master Data Services Q3188157 KB3188157 January 26, 2021
• 3188154 FIX: Can't filter attributes when using SQL Server 2016 Master Data Services Add-in on a non-English version of Excel Q3188154 KB3188154 January 26, 2021
• 3188153 FIX: Long time required to purge many members from an entity in SQL Server 2016 Master Data Services Q3188153 KB3188153 January 26, 2021
• 3188151 FIX: Can't save a business rule when the condition and action refer to different parent entities in SQL Server 2016 Master Data Services Q3188151 KB3188151 January 26, 2021
• 3188150 Version copy fails when an entity contains collections but not consolidated members in SQL Server 2016 MDS Q3188150 KB3188150 January 26, 2021
• 3187549 FIX: Affinity mask does not work correctly for NUMA nodes in SQL Server 2016 Analysis Services Q3187549 KB3187549 January 26, 2021
• 3187493 FIX: DISCOVER_TABLE_STORAGE_COLUMN_SEGMENTS DMV returns an incorrect result of memory usage in SQL Server 2016 Q3187493 KB3187493 January 26, 2021
• 3186435 FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed or stops working after applying SQL Server update Q3186435 KB3186435 January 26, 2021
• 3186433 FIX: Cannot print a SQL Server Reporting Services 2016 report from an application by using Report Viewer Control Q3186433 KB3186433 January 26, 2021
• 3185650 FIX: Access violation occurs when execute a query that contains many COUNT DISTINCT operations in SQL Server 2016 Q3185650 KB3185650 January 26, 2021
• 3184227 "The remote server '(null)' does not exist" error occurs after you remove an article from a publication in SQL Server Q3184227 KB3184227 January 26, 2021
• 3184135 Can't open a Reporting Services report from the SSRS portal when the host computer has FIPS compliance enabled Q3184135 KB3184135 January 26, 2021
• 3184099 SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy Q3184099 KB3184099 January 26, 2021
• 3183721 "The connection string is not valid" error occurs when you use a data source of type Microsoft SharePoint List in SQL Server 2016 Reporting Services Q3183721 KB3183721 January 26, 2021
• 3183686 FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS Q3183686 KB3183686 January 26, 2021
• 3183440 Error when you use SecurityFilteringBehavior enumeration in SQL Server 2016 Analysis Services Q3183440 KB3183440 January 26, 2021
• 3183345 FIX: Publication contains column filters stops working after restored from SQL Server 2005 to SQL Server 2012,2014 or 2016 Q3183345 KB3183345 January 26, 2021
• 3182868 FIX: Queries that contain recursive CROSS APPLY operations run slowly in SQL Server 2016 Q3182868 KB3182868 January 26, 2021
• 3181526 Calculation using two measure time values in iterations returns negative values in SQL Server 2012, 2014, or 2016 Q3181526 KB3181526 January 26, 2021
• 3181444 FIX: Queries that run against secondary databases always get recompiled in SQL Server Q3181444 KB3181444 January 26, 2021
• 3181260 SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server Q3181260 KB3181260 January 26, 2021
• 3180980 Can't export a report as an Excel workbook when the "Interpret HTML Tags as Styles" option is selected Q3180980 KB3180980 January 26, 2021
• 3180263 FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 or 2016 Analysis Services Q3180263 KB3180263 January 26, 2021
• 3180060 FIX: Queries that use CHANGETABLE use much more CPU in SQL Server 2014 SP1 or in SQL Server 2016 Q3180060 KB3180060 January 26, 2021
• 3179258 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200) Q3179258 KB3179258 January 26, 2021
• 3178934 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200) Q3178934 KB3178934 January 26, 2021
• 3178541 PivotTable connects to incorrect data source in SQL Server PowerPivot for SharePoint Q3178541 KB3178541 January 26, 2021
• 3178297 Query Store automatic data cleanup fails on editions other than Enterprise and Developer edition of SQL Server 2016 Q3178297 KB3178297 January 26, 2021
• 3178137 FIX: Potential loss of historical data when you alter an in-memory temporal table in SQL Server 2016 Q3178137 KB3178137 January 26, 2021
• 3178107 SQL Server crashes because of an access violation error that occurs while it reads data from an event file target Q3178107 KB3178107 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
• 3177238 FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server Q3177238 KB3177238 January 26, 2021
• 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Q3176993 KB3176993 January 26, 2021
• 3176440 FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 or 2016 Q3176440 KB3176440 January 26, 2021
• 3175883 Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server Q3175883 KB3175883 January 26, 2021
• 3175478 FIX: It takes a long time to compile a query and add it to the Query Store in SQL Server 2016 Q3175478 KB3175478 January 26, 2021
• 3175205 FIX: Long query contains specific expressions receives syntax error if forced parameterization is enabled in SQL Server 2016 Q3175205 KB3175205 January 26, 2021
• 3175203 FIX: ShortestLineTo() and STDistance() methods return incorrect result for the shortest distance in SQL Server 2016 Q3175203 KB3175203 January 26, 2021
• 3175018 Improvements and fixes for SQL Server 2016 R Services Q3175018 KB3175018 January 26, 2021
• 3174963 FIX: Data loss when you alter column operation on a large memory-optimized table in SQL Server 2016 Q3174963 KB3174963 January 26, 2021
• 3174829 FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016 Q3174829 KB3174829 January 26, 2021
• 3174812 FIX: Queries on Stretch Database enabled databases always involves a network round-trip to Azure in SQL Server 2016 Q3174812 KB3174812 January 26, 2021
• 3174788 The Customer Experience Improvement Program is disabled after FIPS compliance is enabled in SQL Server 2016 Q3174788 KB3174788 January 26, 2021
• 3174713 Data Flush Tasks of a memory-optimized temporal table may consume 100-percent CPU usage in SQL Server 2016 Q3174713 KB3174713 January 26, 2021
• 3174712 A deadlock condition occurs when you make updates on a memory-optimized temporal table and you run the SWITCH PARTITION statement on a history table in SQL Server 2016 Q3174712 KB3174712 January 26, 2021
• 3174711 SYSTEM_VERSIONING is not turned on for a table in a database that has the READ_COMMITTED_SNAPSHOT isolation level enabled in SQL Server 2016 Q3174711 KB3174711 January 26, 2021
• 3174710 Audit record is missing when you turn on SYSTEM_VERSIONING for a table by using the ALTER TABLE statement in SQL Server 2016 Q3174710 KB3174710 January 26, 2021
• 3174708 A memory leak occurs when DATA_CONSISTENCY_CHECK is being executed for a system-versioned temporal table in SQL Server 2016 Q3174708 KB3174708 January 26, 2021
• 3174684 FIX: SQL Server 2016 uses all available memory and crashes when it runs a query that contains HASHBYTES functions Q3174684 KB3174684 January 26, 2021
• 3174674 The full-text search feature does not always return the expected results in SQL Server 2016 Q3174674 KB3174674 January 26, 2021
• 3174436 FIX: Failed execution of ALTER AUDIT statement causes SQL Server to crash in SQL Server 2016 Q3174436 KB3174436 January 26, 2021
• 3174433 FIX: Error 10635 when you rebuild indexes online for tables that contain large object (LOB) columns in SQL Server 2016 Q3174433 KB3174433 January 26, 2021
• 3174395 FIX: sys.dm_external_script_execution_stats returns an incorrect counter_value in SQL Server 2016 Q3174395 KB3174395 January 26, 2021
• 3174393 Windows Authentication doesn't work when you connect to SQL Server from R Script on SQL Server 2016 Express Edition Q3174393 KB3174393 January 26, 2021
• 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 Q3174370 KB3174370 January 26, 2021
• 3174088 FIX: Error 5283 when you run DBCC CHECKDB on a database that contains non-clustered columnstore index in SQL Server 2016 Q3174088 KB3174088 January 26, 2021
• 3173989 FIX: Availability databases are not fully started after you restart the server instance of SQL Server 2016 Q3173989 KB3173989 January 26, 2021
• 3173976 FIX: Fatal Error when you run a query against the sys.sysindexes view in SQL Server 2016 Q3173976 KB3173976 January 26, 2021
• 3173975 FIX: Checkpoint files are missing from sys.dm_db_xtp_checkpoint_files on SQL Server 2016 Q3173975 KB3173975 January 26, 2021
• 3173957 FIX: Cannot install a non-English version of SQL Server 2016 on a Windows Server that is installed in Server Core mode Q3173957 KB3173957 January 26, 2021
• 3173841 A data flush task may cause a deadlock condition when queries are executed on a memory-optimized table in SQL Server 2016 Q3173841 KB3173841 January 26, 2021
• 3173784 An unexpected error occurs when you execute a DAX query that contains variables in SQL Server 2016 Analysis Services Q3173784 KB3173784 January 26, 2021
• 3173781 FIX: Unexpected exception when you make cross-appdomain TOM call in SQL Server 2016 Q3173781 KB3173781 January 26, 2021
• 3173779 FIX: Can’t create a database with a used database name by using the Create or CreateOrReplace command in SQL Server 2016 Q3173779 KB3173779 January 26, 2021
• 3173766 FIX: DBCC CHECKDB or CHECKTABLE returns false positives for data corruption and assertion failures in SQL Server 2014 or 2016 Q3173766 KB3173766 January 26, 2021
• 3173666 The .NET Framework 3.5 is required when you configure SQL Server 2016 as a secondary in Transaction Log Shipping Q3173666 KB3173666 January 26, 2021
• 3173472 SECURITY_CRYPTO_CONTEXT_MUTEX waits cause SQL Server 2016 to stop responding to client requests in SQL Server 2014 and 2016 Q3173472 KB3173472 January 26, 2021
• 3173471 FIX: "Could not redo log record" error, and replica is suspended in SQL Server 2016, 2014, or 2012 Q3173471 KB3173471 January 26, 2021
• 3173436 Behavior changes when you add uniqueidentifier columns in a clustered Columnstore Index in SQL Server 2016 Q3173436 KB3173436 January 26, 2021
• 3173157 Adds a stored procedure for the manual cleanup of the change tracking side table in SQL Server Q3173157 KB3173157 January 26, 2021
• 3173156 Update adds AlwaysOn extended events and performance counters in SQL Server 2014 or 2016 Q3173156 KB3173156 January 26, 2021
• 3173087 FIX: PolyBase feature doesn't install when you add a node to a SQL Server 2016 failover cluster Q3173087 KB3173087 January 26, 2021
• 3173065 SQL Server 2016 generates a dump file when you execute an external script in parallel mode Q3173065 KB3173065 January 26, 2021
• 3173043 FIX: Wrong "schema_name" and "class_type" values for the CREATE SECURITY POLICY statement in SQL Server 2016 Q3173043 KB3173043 January 26, 2021
• 3173038 Performance issues occur when using the sys.dm_hadr_availability_replica_states DMV on an AlwaysOn Availability Group that contains many databases in SQL Server 2016 Q3173038 KB3173038 January 26, 2021
• 3173004 Data loss or incorrect results occur when you use the sp_settriggerorder stored procedure in SQL Server 2016 Q3173004 KB3173004 January 26, 2021
• 3172998 FIX: A severe error when you use the sys.dm_db_uncontained_entities DMV in SQL Server 2014 or 2016 Q3172998 KB3172998 January 26, 2021
• 3172997 Update to add a memory grant warning to the Showplan XML in SQL Server 2014 or 2016 Q3172997 KB3172997 January 26, 2021
• 3172981 FIX: Home page of SSRS web portal becomes empty after you enable My Reports feature in SQL Server 2016 Q3172981 KB3172981 January 26, 2021
• 3172974 FIX: Incorrect number of rows in sys.partitions for a columnstore index in SQL Server 2016 Q3172974 KB3172974 January 26, 2021
• 3172973 FIX: Assertion failure when you run UNION or UNION ALL clauses on a Row-Level Security enabled table in SQL Server 2016 Q3172973 KB3172973 January 26, 2021
• 3172959 FIX: Error 8061 when you use BULK INSERT on a table in SQL Server 2016 Q3172959 KB3172959 January 26, 2021
• 3172787 FIX: Can't force Row Mode sort by using session or query level trace flag 9347 in SQL Server 2016 Q3172787 KB3172787 January 26, 2021
• 3172671 FIX: BULK INSERT or OPENROWSET import wrong data if UTF-8 encoded file does not have a BOM in SQL Server 2016 Q3172671 KB3172671 January 26, 2021
• 3171932 FIX: Error message isn't localized completely when you use Tabular Model Scripting Language (TMSL) in SQL Server 2016 Q3171932 KB3171932 January 26, 2021
• 3171884 FIX: Unexpected exception when you add more maintenance plan tasks for an instance of SQL Server 2012 in SSMS 2016 Q3171884 KB3171884 January 26, 2021
• 3171882 FIX: SSMS can't save maintenance plans when you connect to an instance of SQL Server 2008 R2 or earlier versions Q3171882 KB3171882 January 26, 2021
• 3171863 FIX: Secondary replica in "not healthy" state after you upgrade the primary database in SQL Server 2016 Q3171863 KB3171863 January 26, 2021
• 3171759 A query that accesses data in a columnstore index causes the Database Engine to receive a floating point exception in SQL Server 2016 Q3171759 KB3171759 January 26, 2021
• 3171574 AMO enumeration TraceEventSubclass does not expose member for JsonCommand event subclass in SQL Server 2016 Q3171574 KB3171574 January 26, 2021
• 3171555 Adds trace flag 9358 to disable batch mode sort operations in a complex parallel query in SQL Server 2016 Q3171555 KB3171555 January 26, 2021
• 3171544 FIX: Error 8624 occurs when you run a query against a nonclustered columnstore index in SQL Server 2016 Q3171544 KB3171544 January 26, 2021
• 3171532 Drilling through from one mobile report to another does not respect the embed parameter specified in a URL in SQL Server 2016 Reporting Services Q3171532 KB3171532 January 26, 2021
• 3171516 Update to add a security warning message when you schedule data refresh for PowerPivot workbooks Q3171516 KB3171516 January 26, 2021
• 3171505 FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain Q3171505 KB3171505 January 26, 2021
• 3171489 The Apply button on the Parameter Properties page is not localized in SQL Server 2016 Reporting Services web portal Q3171489 KB3171489 January 26, 2021
• 3171480 FIX: Can't retrieve favorite KPIs or mobile reports in Power BI Mobile app or GetCatalogItem API in SQL Server 2016 Q3171480 KB3171480 January 26, 2021
• 3171475 FIX: Can't rename a catalog item with the same name in different case in SSRS 2016 Q3171475 KB3171475 January 26, 2021
• 3171470 SQL Server 2016 Reporting Services does not upload Service Quality Monitoring data collections Q3171470 KB3171470 January 26, 2021
• 3171469 Cannot open a SSRS paginated report from SQL Server 2016 Reporting Services web portal on an iPad Q3171469 KB3171469 January 26, 2021
• 3171467 Can't pin an SSRS report to Power BI dashboards when you are not a member of any groups on PowerBI.com website Q3171467 KB3171467 January 26, 2021
• 3171085 A report configured to automatically refresh causes errors after the web browser idles for a while in SQL Server 2016 Reporting Services Q3171085 KB3171085 January 26, 2021
• 3171040 "HTTP 503: Service unavailable" error when you open the SSRS web portal after you upgrade to SSRS 2016 Q3171040 KB3171040 January 26, 2021
• 3171002 SQL Server 2016 database log restore fails with the "Hk Recovery LSN is not NullLSN" error message Q3171002 KB3171002 January 26, 2021
• 3171001 FIX: Slow database recovery in SQL Server 2016 due to large log when you use In-Memory OLTP on a high-end computer Q3171001 KB3171001 January 26, 2021
• 3170999 FIX: Heavy concurrent OLTP activity runs slowly when delayed durability is enabled in SQL Server 2016 Q3170999 KB3170999 January 26, 2021
• 3170996 Creating or updating statistics takes a long time on a large memory-optimized table in SQL Server 2016 Q3170996 KB3170996 January 26, 2021
• 3170528 The "BackgroundColor" property is not respected when it is specified by an expression in SQL Server 2016 Reporting Services Q3170528 KB3170528 January 26, 2021
• 3170359 Improvements and fixes for SSRS 2016 mobile report Q3170359 KB3170359 January 26, 2021
• 3170293 Product Update feature doesn't update SQL Server Setup support files during non-English slipstreamed installation of SQL Server 2016 Q3170293 KB3170293 January 26, 2021
• 3170214 FIX: Can't generate an SSIS package when you use SQL Server Import and Export Wizard in SQL Server 2016 Q3170214 KB3170214 January 26, 2021
• 3170145 FIX: SSIS package doesn't run when you call it from executable files outside the DTS\Binn folder in SQL Server 2016 Q3170145 KB3170145 January 26, 2021
• 3170142 Buffer size is not set correctly when AutoAdjustBufferSize is enabled in SQL Server Data Tools in Visual Studio 2015 Q3170142 KB3170142 January 26, 2021
• 3170140 Adds the adjusted buffer size to the BufferSizeTuning event when AutoAdjustBufferSize is enabled in SSIS 2016 Q3170140 KB3170140 January 26, 2021
• 3170132 FIX: Error 7330 when query the view that is created by the Data Feed Publishing Wizard in SQL Server 2016 Q3170132 KB3170132 January 26, 2021
• 3170123 Supports DROP TABLE DDL for articles that are included in transactional replication in SQL Server 2014 or in SQL Server 2016 SP1 Q3170123 KB3170123 January 26, 2021
• 3170116 FIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server Q3170116 KB3170116 January 26, 2021
• 3170115 Information about enabled trace flags is added to the showplan XML in SQL Server Q3170115 KB3170115 January 26, 2021
• 3170114 Update to add DMF sys.dm_db_incremental_stats_properties in SQL Server 2014 or 2016 Q3170114 KB3170114 January 26, 2021
• 3170112 Update to expose maximum memory enabled for a single query in Showplan XML in SQL Server 2014 or 2016 Q3170112 KB3170112 January 26, 2021
• 3170085 Domain-based attributes created by MDS Add-in for Excel are unavailable in SQL Server 2016 Q3170085 KB3170085 January 26, 2021
• 3170084 FIX: Can't insert the NULL value into "ArgumentScript" column when you apply a business rule in SQL Server 2016 MDS Q3170084 KB3170084 January 26, 2021
• 3170083 FIX: Exception occurs when you associate an availability database with MDS web application in SQL Server 2016 Q3170083 KB3170083 January 26, 2021
• 3170082 FIX: Permission issue or failure occurs when you upgrade to SQL Server 2016 Master Data Services Q3170082 KB3170082 January 26, 2021
• 3170081 Deadlock occurs with parallel operations in SQL Server 2016 Master Data Services Q3170081 KB3170081 January 26, 2021
• 3170080 Slow performance when SQL Server 2016 Master Data Services is used on large MDS databases Q3170080 KB3170080 January 26, 2021
• 3170079 FIX: Permission issues when you use SQL Server 2016 Master Data Services Q3170079 KB3170079 January 26, 2021
• 3170078 Can't create an MDS website through a low-privilege account in SQL Server 2016 Q3170078 KB3170078 January 26, 2021
• 3170077 FIX: JavaScript error when you create a MDS subscription view in SQL Server 2016 Q3170077 KB3170077 January 26, 2021
• 3170076 FIX: Data loss when you run the udpConvertCollectionAndConsolidatedMembersToLeaf stored procedure in SQL Server 2016 MDS Q3170076 KB3170076 January 26, 2021
• 3170074 FIX: Unexpected exception occurs when deploying a package using SQL Server 2016 MDSModelDeploy tool Q3170074 KB3170074 January 26, 2021
• 3170071 SQL Server 2016 cannot send diagnostics information for MDS web application and MDS Add-in for Excel Q3170071 KB3170071 January 26, 2021
• 3170068 An unhandled exception occurs after a filter is applied on an attribute in SQL Server 2016 Master Data Services Q3170068 KB3170068 January 26, 2021
• 3170061 An unhandled exception occurs when you reopen a saved workbook that contains MDS entities in SQL Server 2016 Q3170061 KB3170061 January 26, 2021
• 3170051 FIX: SQL Server failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting Q3170051 KB3170051 January 26, 2021
• 3170015 DMV sys.dm_os_memory_nodes returns a non-zero value for the pages_kb value for the DAC node in SQL Server 2014 Q3170015 KB3170015 January 26, 2021
• 3169923 Fixes some issues about assistive technology tools in SSRS 2016 Q3169923 KB3169923 January 26, 2021
• 3169922 Cannot create a new subscription for a report that contains Unicode characters in SQL Server 2016 Reporting Services web portal Q3169922 KB3169922 January 26, 2021
• 3169921 Update to fix layout issues in SQL Server 2016 Reporting Services (SSRS) web portal Q3169921 KB3169921 January 26, 2021
• 3168793 FIX: Cannot create or delete a table or index when another DDL transaction is running on the same database in SQL Server 2016 Q3168793 KB3168793 January 26, 2021
• 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016 Q3168740 KB3168740 January 26, 2021
• 3168710 FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016 Q3168710 KB3168710 January 26, 2021
• 3168709 SQL Server doesn't start after you configure the tempdb database to use a very small log file Q3168709 KB3168709 January 26, 2021
• 3168708 FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server Q3168708 KB3168708 January 26, 2021
• 3168707 FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 or 2016 Q3168707 KB3168707 January 26, 2021
• 3168691 Can't install Microsoft R Server (Standalone) on a Windows Server Core operating system Q3168691 KB3168691 January 26, 2021
• 3168571 FIX: The SEEDING_MODE setting is ignored when you add an AlwaysOn AG replica to an existing AG in SQL Server 2016 Q3168571 KB3168571 January 26, 2021
• 3168570 Update adds FIPS-compliant support in SQL Server 2016 Q3168570 KB3168570 January 26, 2021
• 3168257 Setup UI changes to English if a non-English version of SQL Server 2016 GDR update is installed using the Product Update feature Q3168257 KB3168257 January 26, 2021
• 3168242 FIX: Processor group affinity issues in SQL Server 2016 Analysis Services (Tabular mode) Q3168242 KB3168242 January 26, 2021
• 3168200 FIX: Only one Boolean parameter can select default value when you have multiple Boolean parameters in SSRS 2016 Q3168200 KB3168200 January 26, 2021
• 3167434 FIX: SSRS logs fill up the hard disk and agent jobs are not recreated after database migration in SQL Server 2016 Q3167434 KB3167434 January 26, 2021
• 3167175 FIX: The "Select All" check box doesn't work in the subscriptions page in SSRS 2016 Q3167175 KB3167175 January 26, 2021
• 3167174 FIX: Subscriptions that are filtered out are still affected by the actions in SSRS 2016 Q3167174 KB3167174 January 26, 2021
• 3167159 FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan Q3167159 KB3167159 January 26, 2021
• 3167113 Analysis Services may crash if the HeapTypeForObjects memory property is configured by a slot allocator in SQL Server 2016 Q3167113 KB3167113 January 26, 2021
• 3166120 FIX: "Could not find stored procedure 'sys.sp_cdc_parse_captured_column_list'" error in SQL Server 2016 Q3166120 KB3166120 January 26, 2021
• 3165545 FIX: Unable to execute FORMAT function if it is wrapped inside CLR in SQL Server Q3165545 KB3165545 January 26, 2021
• 3165168 Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server Q3165168 KB3165168 January 26, 2021
• 3163924 AUTOGROW_ALL_FILES and READ_ONLY aren't either updated by DDL or preserved after a database restarts in SQL Server 2016 Q3163924 KB3163924 January 26, 2021
• 3162858 "The log backup chain is broken" error when the log backup process fails in SQL Server Q3162858 KB3162858 January 26, 2021
• 3162589 FIX: Decreased SQL Server performance when there is elevated privileged mode CPU usage and a high volume of page latch waits Q3162589 KB3162589 January 26, 2021
• 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Q3162396 KB3162396 January 26, 2021
• 3161403 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server Q3161403 KB3161403 January 26, 2021
• 3161119 FIX: Change tracking cleanup task fails if another database is offline in SQL Server 2014 or 2016 Q3161119 KB3161119 January 26, 2021
• 3160303 FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 Q3160303 KB3160303 January 26, 2021
• 3159748 FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2014 or 2016 Q3159748 KB3159748 January 26, 2021
• 3158710 FIX: The ALTER SERVER CONFIGURATION with SET SOFTNUMA command does not work in SQL Server 2016 Q3158710 KB3158710 January 26, 2021
• 3158388 FIX: SQL Server 2016 MDS database is not visible in SQL Server 2012 MDS Configuration Manager Q3158388 KB3158388 January 26, 2021
• 3157575 FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server Q3157575 KB3157575 January 26, 2021
• 3156157 Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available Q3156157 KB3156157 January 26, 2021
• 3155503 FIX: MERGE statement to sync tables is unsuccessful when change data capture is enabled in SQL Server 2012, 2014, or 2016 Q3155503 KB3155503 January 26, 2021
• 3155209 FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 Q3155209 KB3155209 January 26, 2021
• 3154226 FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server Q3154226 KB3154226 January 26, 2021
• 3153836 Operating system error 32 when you restore a database in SQL Server 2012 SP3, 2014, or 2016 Q3153836 KB3153836 January 26, 2021
• 3152965 FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server Q3152965 KB3152965 January 26, 2021
• 3152596 FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Q3152596 KB3152596 January 26, 2021
• 3152378 FIX: FileTables in an AlwaysOn availability group become unavailable after failover in an instance of SQL Server Q3152378 KB3152378 January 26, 2021
• 3152377 FIX: Error 5120 when you create or use a FILESTREAM-enabled database on a dynamic disk in an instance of SQL Server 2014 or 2016 Q3152377 KB3152377 January 26, 2021
• 3152135 FIX: An access violation occurs when you run a spatial query that contains OPENQUERY methods through a linked server in SQL Server 2014 or 2016 Q3152135 KB3152135 January 26, 2021
• 3152042 FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Q3152042 KB3152042 January 26, 2021
• 3150896 FIX: A "Non-yielding Scheduler" condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server Q3150896 KB3150896 January 26, 2021
• 3150152 FIX: Estimated number of rows is calculated incorrectly for a predicate involving a unique GUID column in SQL Server 2014 or 2016 Q3150152 KB3150152 January 26, 2021
• 3149128 Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server Q3149128 KB3149128 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
• 3146404 FIX: Canceling a backup task crashes SQL Server Q3146404 KB3146404 January 26, 2021
• 3146123 Query plan generation improvement for some columnstore queries in SQL Server 2014 or 2016 Q3146123 KB3146123 January 26, 2021
• 3138321 FIX: "Non-yielding Scheduler" condition when you run a query that contains a UNION operation in SQL Server 2014 or 2016 Q3138321 KB3138321 January 26, 2021
• 3136496 FIX: Access violation occurs when a query references an SQLCLR function through a synonym in SQL Server 2014 and 2016 Q3136496 KB3136496 January 26, 2021
• 3136205 FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server Q3136205 KB3136205 January 26, 2021
• 3132062 FIX: SMK initialization fails on one node of a SQL Server 2012, 2014, or 2016 failover cluster Q3132062 KB3132062 January 26, 2021
• 3132058 FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server Q3132058 KB3132058 January 26, 2021
• 3131443 FIX: "Cannot resolve the collation conflict" error when you apply a snapshot to the subscriber database in SQL Server Q3131443 KB3131443 January 26, 2021
• 3122088 Sqlps utility fails to run when the "Turn on Script Execution" policy is set to "Allow all scripts" in SQL Server Q3122088 KB3122088 January 26, 2021
• 3115741 FIX:"The process cannot access the file" error when an XML task fails in SQL Server Q3115741 KB3115741 January 26, 2021
• 3107397 Improved diagnostics for query execution plans that involve residual predicate pushdown in SQL Server Q3107397 KB3107397 January 26, 2021
• 3106976 FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 or 2016 Q3106976 KB3106976 January 26, 2021
• 3100256 "Log provider "Microsoft.LogProviderSQLServer" is not installed correctly" error when you open the Configure SSIS Logs window Q3100256 KB3100256 January 26, 2021
• 3070382 FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name Q3070382 KB3070382 January 26, 2021
• 3067968 FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 or 2016 Q3067968 KB3067968 January 26, 2021
• 3065060 FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS Q3065060 KB3065060 January 26, 2021
• 3030352 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database Q3030352 KB3030352 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
• 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Q3025408 KB3025408 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
• 3009974 FIX: Slow synchronization when disks have different sector sizes for primary and secondary replica log files in SQL Server AG and Logshipping environments Q3009974 KB3009974 January 26, 2021
• 3005011 Unexpected growth of tempdb data files when using SQL Server Service Broker Q3005011 KB3005011 January 26, 2021
• 2963836 FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS Q2963836 KB2963836 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
• 2925865 Error when you execute SSIS package on FIPS-enabled Windows Q2925865 KB2925865 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
• 4534430 Msg 33111 error after SQL Server TDE certificate or key rotation Q4534430 KB4534430 January 25, 2021
• 4458842 Description of the security update for the remote code execution vulnerability in SQL Server 2016 SP1 (GDR): August 22, 2018 Q4458842 KB4458842 January 25, 2021
• 4458621 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 21, 2018 Q4458621 KB4458621 January 25, 2021
• 4293808 Description of the security update for the remote code execution vulnerability in SQL Server 2016 SP1 (CU): August 14, 2018 Q4293808 KB4293808 January 25, 2021
• 4293807 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 14, 2018 Q4293807 KB4293807 January 25, 2021
• 4293802 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (GDR): August 14, 2018 Q4293802 KB4293802 January 25, 2021
• 4293801 Description of the security update for the remote code execution vulnerability in SQL Server 2016 SP1 (GDR): August 14, 2018 Q4293801 KB4293801 January 25, 2021
• 4019095 Description of the security update for SQL Server 2016 Service Pack 1 CU: August 8, 2017 Q4019095 KB4019095 January 25, 2021
• 4019089 Description of the security update for SQL Server 2016 Service Pack 1 GDR: August 8, 2017 Q4019089 KB4019089 January 25, 2021
• 4019088 Description of the security update for SQL Server 2016 RTM GDR: August 8, 2017 Q4019088 KB4019088 January 25, 2021
• 4019086 Description of the security update for SQL Server 2016 RTM CU: August 8, 2017 Q4019086 KB4019086 January 25, 2021
• 3203693 “A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10 Q3203693 KB3203693 January 25, 2021
• 3199641 MS16-136: Security update for SQL Server: November 8, 2016 Q3199641 KB3199641 January 25, 2021
• 3194717 MS16-136: Description of the security update for SQL Server 2016 CU: November 8, 2016 Q3194717 KB3194717 January 25, 2021
• 3194716 MS16-136: Description of the security update for SQL Server 2016 GDR: November 8, 2016 Q3194716 KB3194716 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
• 3164398 Critical update for SQL Server 2016 MSVCRT prerequisites Q3164398 KB3164398 January 25, 2021
• 3108695 Client connectivity issues because of changes in name resolution in SQL Server 2014 or later Q3108695 KB3108695 January 25, 2021
• 3045321 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015 Q3045321 KB3045321 January 25, 2021
• 2953354 FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server Q2953354 KB2953354 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
• 4583461 Description of the security update for SQL Server 2016 SP2 CU15: January 12, 2021 Q4583461 KB4583461 January 16, 2021
• 4583460 Description of the security update for SQL Server 2016 SP2 GDR: January 12, 2021 Q4583460 KB4583460 January 16, 2021
• 4535833 SQL Server Reporting Services XSS vulnerability Q4535833 KB4535833 January 14, 2021
• 4535706 Description of the security update for SQL Server 2016 SP2 CU11: February 11, 2020 Q4535706 KB4535706 January 14, 2021
• 4535305 SQL Server Reporting Services remote code execution vulnerability Q4535305 KB4535305 January 14, 2021
• 4532097 Description of the security update for SQL Server 2016 SP2 GDR: February 11, 2020 Q4532097 KB4532097 January 14, 2021
• 4505222 Description of the security update for SQL Server 2016 SP2 CU7: July 9, 2019 Q4505222 KB4505222 January 14, 2021
• 4505221 Description of the security update for SQL Server 2016 SP1 CU15: July 9, 2019 Q4505221 KB4505221 January 14, 2021
• 4505220 Description of the security update for SQL Server 2016 SP2 GDR: July 9, 2019 Q4505220 KB4505220 January 14, 2021
• 4505219 Description of the security update for SQL Server 2016 SP1 GDR: July 9, 2019 Q4505219 KB4505219 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
• 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
• 4469942 FIX: Sharing violation when the "sp_cycle_agent_errorlog" stored procedure is run in SQL Server Q4469942 KB4469942 January 14, 2021
• 4469349 FIX: VSS backup fails in SQL Server 2008 after you install CU10 for SQL Server 2016 SP1 in the same virtual machine Q4469349 KB4469349 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
• 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
• 4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016 and 2017 Q4466994 KB4466994 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
• 4466793 FIX: Assertion error occurs when you restart the SQL Server 2016 database Q4466793 KB4466793 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
• 4465249 FIX: “ORA-01036: illegal variable name/number” when you query an Oracle database in SSAS 2016 Q4465249 KB4465249 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
• 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
• 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
• 4341221 FIX: VSS backup fails in secondary replica of Basic Availability Groups in SQL Server 2016 and 2017 Q4341221 KB4341221 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
• 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
• 4338240 FIX: Toggle item, font color, and background color expressions do not work correctly together in SSRS Q4338240 KB4338240 January 14, 2021
• 4338204 FIX: Circular dependency between column names for a calculated table that summarizes the partition query dataset in SQL Server Q4338204 KB4338204 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
• 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
• 4230516 FIX: A memory assertion failure occurs, and the server can't make new connections in SQL Server Q4230516 KB4230516 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
• 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
• 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
• 4131960 FIX: Access violation when you run a nested select query against a columnstore index in SQL Server Q4131960 KB4131960 January 14, 2021
• 4131251 FIX: Thai characters in SSAS for SQL Server exported to a PDF file are displayed incorrectly Q4131251 KB4131251 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
• 4099490 On-demand hotfix update package for SQL Server 2016 SP1 Q4099490 KB4099490 January 14, 2021
• 4094893 FIX: Database can't be dropped after its storage is disconnected and reconnected in SQL Server Q4094893 KB4094893 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
• 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
• 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
• 4089099 FIX: It takes a long time to restore a TDE-encrypted database backup in SQL Server Q4089099 KB4089099 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
• 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
• 4082865 FIX: SSAS crashes when a query is executed on a large partitioned table in SQL Server 2016 Q4082865 KB4082865 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
• 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
• 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
• 4057307 FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 Q4057307 KB4057307 January 14, 2021
• 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Q4053693 KB4053693 January 14, 2021
• 4053293 PolyBase support added for SSL-secured Hadoop clusters and access to Encryption Zones Q4053293 KB4053293 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
• 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
• 4051359 FIX: SQL Server runs out of memory when table-valued parameters are captured in Extended Events sessions in SQL Server 2016 even if collecting statement or data stream isn't enabled Q4051359 KB4051359 January 14, 2021
• 4046885 FIX: The SQL Server 2016 setup page contains nonsecure tool-download links Q4046885 KB4046885 January 14, 2021
• 4046858 FIX: Parallel query execution plan with "merge join" slow to execute in Cumulative Update 3, 4, or 5 for SQL Server 2016 Service Pack 1 Q4046858 KB4046858 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
• 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
• 4040539 FIX: Error when using sp_execute_external_script stored procedure to insert data and specify @parallel value to 1 in SQL Server 2016 Q4040539 KB4040539 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
• 4040014 FIX: Query that joins a view and contains UNION ALL slow in SQL Server 2016 Q4040014 KB4040014 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
• 4039735 FIX: "Non-yielding Scheduler" condition occurs for query with many expressions in SQL Server 2014 and 2016 Q4039735 KB4039735 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
• 4025628 FIX: Error 9004 when you try to restore a compressed backup from multiple files for a large TDE-encrypted database in SQL Server Q4025628 KB4025628 January 14, 2021
• 4025021 FIX: Blank spaces in the parameter area when you open SSRS report that contains Hidden or Internal parameters in SQL Server 2016 Q4025021 KB4025021 January 14, 2021
• 4024989 FIX: "EXCEPTION_INVALID_CRT_PARAMETER" error with BULK INSERT statement in SQL Server 2016 Q4024989 KB4024989 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
• 4024840 FIX: Access violation occurs when trace flag 176 enabled in SQL Server 2016 Q4024840 KB4024840 January 14, 2021
• 4024563 FIX: Unhandled exception when you export a SSRS report to a .pdf file if the page height is set to 8.5 inches in SQL Server 2014 or 2016 Q4024563 KB4024563 January 14, 2021
• 4024392 FIX: "Non-yielding Scheduler" condition occurs when you change the BUCKET_COUNT value for large memory-optimized tables in Microsoft SQL Server 2016 Q4024392 KB4024392 January 14, 2021
• 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 Q4024184 KB4024184 January 14, 2021
• 4023679 FIX: Timeout when you back up a large database to URL in SQL Server 2014 or 2016 Q4023679 KB4023679 January 14, 2021
• 4023138 FIX: "Incorrect syntax" error when you add a subscription by using the "sp_addpullsubscription_agent" stored procedure in SQL Server Q4023138 KB4023138 January 14, 2021
• 4022874 FIX: The FILESTREAM feature in SQL Server is disabled after you install Windows 10 Creators Update Q4022874 KB4022874 January 14, 2021
• 4022435 FIX: Parallel query execution returns incorrect results for merge join operations in SQL Server 2016 Q4022435 KB4022435 January 14, 2021
• 4021405 FIX: An access violation occurs when you create an index with page compression in SQL Server Q4021405 KB4021405 January 14, 2021
• 4020747 FIX: SQL Server 2016 crashes with an access violation in sqlmin!TListElem when you execute R scripts Q4020747 KB4020747 January 14, 2021
• 4019983 FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report Q4019983 KB4019983 January 14, 2021
• 4019978 FIX: "Error occurred during rendering" when you export a report as a PowerPoint presentation in SQL Server 2016 Reporting Services Q4019978 KB4019978 January 14, 2021
• 4019863 FIX: Assertion occurs when you run an ALTER TABLE SWITCH statement on a partitioned temporal history table in SQL Server 2016 Q4019863 KB4019863 January 14, 2021
• 4019715 FIX: SQL Server 2016 does not log error messages that have a severity level of 21 for checksum mismatches found in In-Memory OLTP checkpoint files Q4019715 KB4019715 January 14, 2021
• 4019701 FIX: Database schema is corrupted when you restore a database from a snapshot in SQL Server Q4019701 KB4019701 January 14, 2021
• 4019603 FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 Q4019603 KB4019603 January 14, 2021
• 4019446 FIX: SQL Server 2016 stops responding when the "Latch_Suspend_End" extended event is incorrectly triggered Q4019446 KB4019446 January 14, 2021
• 4019286 FIX: SQL Server 2016 Reporting Service subscription incorrectly sends a PDF attachment as an "Application/Octet-Stream" MIME type Q4019286 KB4019286 January 14, 2021
• 4019125 FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column Q4019125 KB4019125 January 14, 2021
• 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server Q4018227 KB4018227 January 14, 2021
• 4016850 FIX: Incorrect results when you use SQL Server Management Objects to generate a script for a full-text Search index Q4016850 KB4016850 January 14, 2021
• 4016805 FIX: The SQL Server Analysis Service encounters an internal error when it processes a Tabular model Q4016805 KB4016805 January 14, 2021
• 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 Q4016804 KB4016804 January 14, 2021
• 4016238 FIX: DBCC CLONEDATABASE is unsuccessful if the source database has an object originally created in SQL Server 2000 Q4016238 KB4016238 January 14, 2021
• 4014798 Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server Q4014798 KB4014798 January 14, 2021
• 4014719 FIX: "(0x80004002) No such interface supported" error when you use RMO to run Web Synchronization for Merge Replication in SQL Server 2016 Q4014719 KB4014719 January 14, 2021
• 4014706 FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server Q4014706 KB4014706 January 14, 2021
• 4014031 FIX: Incorrect data when a subscription runs on a computer whose time zone differs from the report server time zone in SQL Server 2016 Reporting Services Q4014031 KB4014031 January 14, 2021
• 4014013 FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 Q4014013 KB4014013 January 14, 2021
• 4013999 FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2016 Q4013999 KB4013999 January 14, 2021
• 4013877 Update enables DML query plan to scan query memory-optimized tables in parallel in SQL Server 2016 Q4013877 KB4013877 January 14, 2021
• 4013585 FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data Q4013585 KB4013585 January 14, 2021
• 4013207 FIX: "Incorrect syntax for definition of the 'default' constraint" error when you add an arbitrary columnstore column in SQL Server 2016 Q4013207 KB4013207 January 14, 2021
• 4013206 FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance Q4013206 KB4013206 January 14, 2021
• 4013125 Update improves DMV sys.dm_server_services and sys.dm_os_sys_info in SQL Server 2016 Q4013125 KB4013125 January 14, 2021
• 4013124 FIX: An access violation occurs when natively compiled stored procedures are executed concurrently in SQL Server 2016 Q4013124 KB4013124 January 14, 2021
• 4013119 FIX: DBCC CLONEDATABASE doesn't copy the runtime cache of the query store to the clone in SQL Server 2016 SP1 Q4013119 KB4013119 January 14, 2021
• 4013118 FIX: The sys.column_store_segments catalog view displays incorrect values in the column_id column in SQL Server 2016 Q4013118 KB4013118 January 14, 2021
• 4013116 FIX: ALTER TABLE, ADD CONSTRAINT, and PRIMARY KEY statements do not detect a duplicate key in SQL Server 2016 Q4013116 KB4013116 January 14, 2021
• 4013115 FIX: CREATE OR ALTER statement applied on a DDL trigger fails on the next execution in SQL Server 2016 Q4013115 KB4013115 January 14, 2021
• 4013112 FIX: "ADD PERIOD FOR SYSTEM_TIME failed" error when you add period columns to a memory-optimized table in SQL Server 2016 Q4013112 KB4013112 January 14, 2021
• 4013111 FIX: DMV sys.dm_hadr_availability_group_states displays "NOT_HEALTHY" in synchronization_health_desc column on secondary replicas in SQL Server Q4013111 KB4013111 January 14, 2021
• 4011477 FIX: DMF sys.dm_db_incremental_stats_properties doesn't show all partitions if partitioning column is set to character or binary data type Q4011477 KB4011477 January 14, 2021
• 3212318 FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database Q3212318 KB3212318 January 14, 2021
• 3195752 FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016 Q3195752 KB3195752 January 14, 2021
• 3093930 "Directory name is invalid" error when you try to install a SQL Server CAB (.exe) package by using Microsoft Edge in Windows 10 Q3093930 KB3093930 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
• 4038456 Msg 104381 when running INSERT...SELECT statement in Analytics Platform System 2016 or later Q4038456 KB4038456 January 13, 2021
• 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 January 12, 2021