kbupdate.info ›
Daily Updated!
SQL Server 2016 articles, fixes and updates - Year 2020
Daily Updated!
chronological list: 2023 | ... 10 9 8 7 6 5 4 3 2 1 | 2020 | 2019 | 2018 | 2017 | 2016
alphabetical list: A B C D E F G H I J L M N O P Q R S T U V W X Y
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 Year 2020. The list is daily updated.
- 4038932 FIX: Change Data Capture functionality does not work in SQL Server Q4038932 KB4038932 December 24, 2020
- 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
- 307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database" Q307864 KB307864 December 17, 2020
- 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 1, 2020
- 955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure Q955644 KB955644 November 8, 2020
- 4560494 FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS Q4560494 KB4560494 October 24, 2020
- 4533057 "Query optimizer generated too many subcubes" error and MDX query fails in SSAS multidimensional instance Q4533057 KB4533057 October 24, 2020
- 4470999 FIX: Problems occur in database backups from older versions of SQL Server Connector for Microsoft Azure Key Vault to version 1.0.5.0 Q4470999 KB4470999 October 24, 2020
- 4016853 FIX: Deadlock when apps try to acquire or refresh an authentication token through Azure Key Vault Provider for Always Encrypted Q4016853 KB4016853 October 24, 2020
- 4587239 FIX: Assertion error occurs when the Availability Group is failed over manually to another replica in SQL Server 2016 Q4587239 KB4587239 October 23, 2020
- 4578496 FIX: Slow performance occurs as CMEMTHREAD waits occur due to temporary table cachestore memory object contention in SQL Server 2016 and 2017 Q4578496 KB4578496 October 23, 2020
- 4578008 FIX: Managed backup is not backing up the database when SQL Agent system jobs are changed to different name other than 'sa' in SQL Server 2016 and 2017 Q4578008 KB4578008 October 23, 2020
- 4576757 FIX: Access violation occurs when you query cloned database in SQL Server 2016 Q4576757 KB4576757 October 23, 2020
- 4568653 FIX: INSERT EXEC doesn't work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server Q4568653 KB4568653 October 23, 2020
- 4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 October 23, 2020
- 4562173 FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times Q4562173 KB4562173 October 23, 2020
- 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 October 23, 2020
- 4556096 FIX: SSRS 2016 URLs are case-sensitive after applying Security Update GDRs KB4532097 or KB4535706 Q4556096 KB4556096 October 23, 2020
- 4548751 App-V Server publishing might fail when you apply user configuration files with SQL Server 2016 or later Q4548751 KB4548751 October 23, 2020
- 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 October 23, 2020
- 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 October 23, 2020
- 4541769 FIX: Error occurs when running sp_updatestats on the table that has a clustered columnstore index and memory optimized index Q4541769 KB4541769 October 23, 2020
- 4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 October 23, 2020
- 4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 October 23, 2020
- 4541520 FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server Q4541520 KB4541520 October 23, 2020
- 4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 October 23, 2020
- 4541385 FIX: Database initialization may fail by using automatic seeding in SQL Server 2016 Q4541385 KB4541385 October 23, 2020
- 4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 October 23, 2020
- 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 October 23, 2020
- 4541288 FIX: Non-yielding scheduler dumps occur when running a batch mode query with multiple joins in SQL Server 2016 Q4541288 KB4541288 October 23, 2020
- 4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 October 23, 2020
- 4540903 FIX: Non-yielding scheduler dump occurs in InterlockedCompareExchangePointer and SOS_RWLock in SQL Server 2016, 2017 and 2019 Q4540903 KB4540903 October 23, 2020
- 4540901 FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016, 2017 and 2019 Q4540901 KB4540901 October 23, 2020
- 4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 October 23, 2020
- 4540731 FIX: Unexpected exception error occurs when you run DISCOVER_CSDL_METADATA in Power BI Desktop in SQL Server 2016 Q4540731 KB4540731 October 23, 2020
- 4540449 FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2016, 2017 and 2019 Q4540449 KB4540449 October 23, 2020
- 4540385 FIX: DAX query causes server to have exceptions in TBB heap and crash in Windows heap in SQL Server 2016 and 2017 Q4540385 KB4540385 October 23, 2020
- 4540346 FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016, 2017 and 2019 Q4540346 KB4540346 October 23, 2020
- 4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 October 23, 2020
- 4540107 FIX: System or background task may fail when number of sessions reaches the maximum limit in SQL Server 2016, 2017 and 2019 Q4540107 KB4540107 October 23, 2020
- 4539947 FIX: Assertion occurs when you run DATABASE SCOPED command in SQL Server 2016 Q4539947 KB4539947 October 23, 2020
- 4539897 FIX: Access violation may occur when you run XML query against a table that has a primary XML index in SQL Server 2016 Q4539897 KB4539897 October 23, 2020
- 4539892 FIX: Error occurs when you run a stored procedure from database A which pulls data from database B in SQL Server 2016 Q4539892 KB4539892 October 23, 2020
- 4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 October 23, 2020
- 4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 October 23, 2020
- 4538378 FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only Q4538378 KB4538378 October 23, 2020
- 4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 October 23, 2020
- 4531027 FIX: Assertion error occurs when you run getHKTable function to get Hekaton database in SQL Server 2016 Q4531027 KB4531027 October 23, 2020
- 4531010 FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server Q4531010 KB4531010 October 23, 2020
- 4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server Q4530720 KB4530720 October 23, 2020
- 4530500 FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server Q4530500 KB4530500 October 23, 2020
- 4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 October 23, 2020
- 4530443 FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned Q4530443 KB4530443 October 23, 2020
- 4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 October 23, 2020
- 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 October 23, 2020
- 4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 October 23, 2020
- 4529942 FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 Q4529942 KB4529942 October 23, 2020
- 4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 October 23, 2020
- 4528130 FIX: Access violation occurs when you restore the In-Memory Optimized database in SQL Server 2016 and 2017 Q4528130 KB4528130 October 23, 2020
- 4528067 FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server Q4528067 KB4528067 October 23, 2020
- 4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 October 23, 2020
- 4528065 FIX: DBCC CHECKDB with EXTENDED_LOGICAL_CHECKS fails on a table in SQL Server 2016 Q4528065 KB4528065 October 23, 2020
- 4527716 FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server Q4527716 KB4527716 October 23, 2020
- 4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 October 23, 2020
- 4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 October 23, 2020
- 4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 October 23, 2020
- 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 October 23, 2020
- 4525612 FIX: BorderStyle property of TextBox controls may not be rendered in EXCELOPENXML format in SQL Server 2016 Q4525612 KB4525612 October 23, 2020
- 4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 October 23, 2020
- 4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 October 23, 2020
- 4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 October 23, 2020
- 4522134 FIX: Subscriptions fail after you upgrade from SSRS 2012 to SSRS 2016 because of invalid character in mail header Q4522134 KB4522134 October 23, 2020
- 4522127 FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi-column statistics Q4522127 KB4522127 October 23, 2020
- 4522126 FIX: You may receive wrong results when you query sys.database_scoped_configurations in SQL Server 2016 Q4522126 KB4522126 October 23, 2020
- 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 October 23, 2020
- 4521701 FIX: Cardinality property for a table doesn't include rows in the delta store or deleted bitmap if the table has a clustered columnstore index Q4521701 KB4521701 October 23, 2020
- 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 Q4521659 KB4521659 October 23, 2020
- 4520739 FIX: Access violation error occurs when you try to insert results of stored procedure into a table with dynamic data masking in SQL Server 2016 and 2017 Q4520739 KB4520739 October 23, 2020
- 4520266 FIX: When you change SEEDING_MODE to MANUAL using ALTER AVAILABILITY GROUP, SQL Server 2016 does not cancel the current seeding operations to the secondary replica Q4520266 KB4520266 October 23, 2020
- 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol Q4520124 KB4520124 October 23, 2020
- 4520109 FIX: Access violation occurs when you restore In-Memory OLTP database in SQL Server 2016 Q4520109 KB4520109 October 23, 2020
- 4519847 FIX: MDS Configuration Manager reports SP2 base version in SQL Server 2016 Q4519847 KB4519847 October 23, 2020
- 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 October 23, 2020
- 4519682 FIX: Azure Site Recovery and other VSS jobs may report failures on servers hosting SQL Server 2016 instances Q4519682 KB4519682 October 23, 2020
- 4519679 FIX: Different users get the same model list with different permissions in SQL Server 2016 and 2017 Q4519679 KB4519679 October 23, 2020
- 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 Q4519668 KB4519668 October 23, 2020
- 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 October 23, 2020
- 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 Q4518364 KB4518364 October 23, 2020
- 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 October 23, 2020
- 4513238 FIX: Error 9003 occurs when you back up a database on a secondary replica in Microsoft SQL Server 2016 and 2017 Q4513238 KB4513238 October 23, 2020
- 4513236 FIX: Internal thread deadlock may occur on primary or secondary replica of availability group in SQL Server 2016 SP2 and 2017 Q4513236 KB4513236 October 23, 2020
- 4513099 FIX: Azure storage I/O subsystem may not reset transfer details for a failed I/O resulting in backup errors Q4513099 KB4513099 October 23, 2020
- 4513097 FIX: Restore or RESTORE VERIFYONLY of a TDE-compressed backup fails in SQL Server 2016 and 2017 Q4513097 KB4513097 October 23, 2020
- 4513096 FIX: Repair fails for Machine Learning components on server with no Internet access Q4513096 KB4513096 October 23, 2020
- 4512956 FIX: Querying sys.tables returns temporary tables created by concurrent users starting from SQL Server 2012 Q4512956 KB4512956 October 23, 2020
- 4512821 FIX: Multidimensional mode randomly crashes and an access violation occurs in SQL Server 2016 Q4512821 KB4512821 October 23, 2020
- 4512558 FIX: Assertion error occurs when SQL Server 2016 and 2017 use hash join, hash aggregate, sort or window function in batch-mode plan Q4512558 KB4512558 October 23, 2020
- 4512130 FIX: Data masking may not be applied when you use PIVOT or UNPIVOT function on masked column in SQL Server 2016 and 2017 Q4512130 KB4512130 October 23, 2020
- 4511868 FIX: Error 409 occurs when you back up databases by using BackuptoURL Q4511868 KB4511868 October 23, 2020
- 4511834 FIX: Memory dumps generate when access violation occurs in SQL Server 2016 Q4511834 KB4511834 October 23, 2020
- 4511816 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016 Q4511816 KB4511816 October 23, 2020
- 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 23, 2020
- 4511751 FIX: Access violation error occurs when SQL Server 2016 and 2017 uses hash join, hash aggregate, sort or window function in batch-mode plan in the deadlock monitor Q4511751 KB4511751 October 23, 2020
- 4511715 FIX: Filled transaction log causes outages when you run Query Store in SQL Server 2016 and 2017 Q4511715 KB4511715 October 23, 2020
- 4510934 FIX: Prolonged non-transactional usage of FileTable without instance restart may cause non-yielding scheduler error or server crash in SQL Server 2014, 2016 and 2017 Q4510934 KB4510934 October 23, 2020
- 4508621 FIX: Data processing is much slower in SSAS 2016 SP2 and 2017 than in SSAS 2016 SP1 Q4508621 KB4508621 October 23, 2020
- 4508472 FIX: Intermittent "row not found" error at Azure SQL DB Subscriber caused by duplication of BEGIN TRAN statements Q4508472 KB4508472 October 23, 2020
- 4504511 Improvement: Allow altering external data source in APS in SQL Server 2016 Q4504511 KB4504511 October 23, 2020
- 4503417 FIX: Assertion dump occurs when you select a view on a linked server in SQL Server 2017, 2016, or 2014 Q4503417 KB4503417 October 23, 2020
- 4503385 FIX: DAX query requires more than 200 times of memory than the size of the database in SQL Server 2016 and 2017 multidimensional model database Q4503385 KB4503385 October 23, 2020
- 4502658 FIX: "No valid credentials provided" occurs after you restart PolyBase in SQL Server 2016 and 2017 Q4502658 KB4502658 October 23, 2020
- 4502427 FIX: Access violation occurs when you run sys.fn_dump_dblog function in SQL Server 2016 and 2017 Q4502427 KB4502427 October 23, 2020
- 4502400 FIX: SQL Server 2014, 2016 and 2017 do not perform the requested pre-row assignments when you use MERGE statement that performs assignments of local variables for each row Q4502400 KB4502400 October 23, 2020
- 4501797 FIX: Data movement to DAG Forwarder does not resume automatically after connection time-out in SQL Server 2016 and 2017 Q4501797 KB4501797 October 23, 2020
- 4501741 FIX: URL encoding is incorrect when the Excel workbook name is in Russian language in SSRS 2016 Q4501741 KB4501741 October 23, 2020
- 4501052 Improvement: Enable PDW APS to access TRY_CONVERT() function in SQL Server 2016 Q4501052 KB4501052 October 23, 2020
- 4500770 FIX: AG is suspended when cross-database transaction is applied on AG databases in SQL Server 2016 and 2017 Q4500770 KB4500770 October 23, 2020
- 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 October 23, 2020
- 4500327 FIX: Non-yielding scheduler issue occurs when you run queries in batch mode that spill in SQL Server 2016 and 2017 Q4500327 KB4500327 October 23, 2020
- 4499231 FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014, 2016 and 2017 Q4499231 KB4499231 October 23, 2020
- 4497701 FIX: Columnstore filter pushdown may return wrong results when there is an overflow in filter expressions in SQL Server 2014, 2016 and 2017 Q4497701 KB4497701 October 23, 2020
- 4497230 FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014, 2016 and 2017 Q4497230 KB4497230 October 23, 2020
- 4497225 FIX: Query against table with both clustered columnstore index and nonclustered rowstore index may return incorrect results in SQL Server 2016 and 2017 Q4497225 KB4497225 October 23, 2020
- 4495663 FIX: Error 41162 occurs when the creation of distributed availability groups fails in SQL Server 2016 and 2017 Q4495663 KB4495663 October 23, 2020
- 4495547 FIX: Remote ad hoc queries that use OPENDATASOURCE produce an incorrect error message when the new OLE DB provider is used Q4495547 KB4495547 October 23, 2020
- 4493765 FIX: HTML files cannot be opened directly from the web portal in SSRS 2016 Q4493765 KB4493765 October 23, 2020
- 4493363 FIX: Masked data may be exposed when a query manipulates the data using a temporary table in SQL Server 2016 and 2017 Q4493363 KB4493363 October 23, 2020
- 4492899 FIX: FileTable database level directory is inaccessible after database startup in SQL Server 2016 and 2017 Q4492899 KB4492899 October 23, 2020
- 4492880 FIX: Automatic seeding assertions occur when databases are removed from AG in SQL Server 2016 and 2017 Q4492880 KB4492880 October 23, 2020
- 4492762 FIX: SQL Trace Collection Set fails when you click "Collect and Upload Now" in SQL Server 2016 Q4492762 KB4492762 October 23, 2020
- 4492604 FIX: Manual failover between forwarder and secondary replica fails with all replicas synchronized in SQL Server 2016 and 2017 Q4492604 KB4492604 October 23, 2020
- 4491696 FIX: Floating point exception error 3628 occurs when you query DMV sys.dm_db_xtp_hash_index_stats in SQL Server 2016 Q4491696 KB4491696 October 23, 2020
- 4490435 FIX: "The given key was not present in the dictionary" occurs if you do a preview in the CDC Source in SQL Server 2016 Q4490435 KB4490435 October 23, 2020
- 4490237 FIX: Restoring backup to SQL Server 2016 and 2017 from SQL Server 2008 or 2008 R2 takes a long time Q4490237 KB4490237 October 23, 2020
- 4490141 Improvement: DMV sys.dm_hadr_cluster reports cloud witness quorum type "4" and quorum_type_desc "UNKNOWN_QUORUM" in SQL Server 2016 and 2017 Q4490141 KB4490141 October 23, 2020
- 4490136 FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016 and 2017 Q4490136 KB4490136 October 23, 2020
- 4489202 FIX: Error 10314 occurs when you load .NET CLR assembly in SQL Server 2016 and 2017 database Q4489202 KB4489202 October 23, 2020
- 4489150 FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014, 2016 and 2017 Q4489150 KB4489150 October 23, 2020
- 4488971 FIX: MDS database upgrade fails with error in SQL Server 2016 and 2017 Q4488971 KB4488971 October 23, 2020
- 4488949 FIX: Assertion occurs when linked server which points to itself is used in a cross-database transaction in SQL Server 2016 and 2017 Q4488949 KB4488949 October 23, 2020
- 4488856 FIX: Error 2812 and 20028 occur when you drop publisher or enable database for publication after you upgrade your SQL Server 2016 and 2017 Q4488856 KB4488856 October 23, 2020
- 4488853 FIX: 'MSrepl_agent_jobs' does not exist when you run sp_addpullsubscription_agent to create pull subscription in SQL Server 2016 and 2017 Q4488853 KB4488853 October 23, 2020
- 4488817 FIX: FILESTREAM for file I/O access feature can't be enabled when you use Cluster Shared Volumes (CSV) in SQL Server 2016 and 2017 Failover Cluster Instances Q4488817 KB4488817 October 23, 2020
- 4488809 FIX: Assertion occurs when a parallel query deletes from a Filestream table in SQL Server 2014, 2016 and 2017 Q4488809 KB4488809 October 23, 2020
- 4488036 FIX: Repl_Schema_Access wait issues when there are multiple publisher databases on the same instance of SQL Server 2016 and 2017 Q4488036 KB4488036 October 23, 2020
- 4487094 FIX: Delays when Query Store Async Load is enabled in SQL Server 2016 Q4487094 KB4487094 October 23, 2020
- 4486941 Improvement: A way to configure logging for Hadoop bridge in PolyBase in SQL Server 2016 Q4486941 KB4486941 October 23, 2020
- 4486940 FIX: Assertion failure occurs when you try to back up database in limited disk space in SQL Server 2016 and 2017 Q4486940 KB4486940 October 23, 2020
- 4486937 FIX: Publishing MDS data from Excel fails when you save the changes to workbook, close and reopen it in SQL Server 2016 and 2017 Q4486937 KB4486937 October 23, 2020
- 4486935 FIX: Query results are not as expected when you run a particular query from Excel in SQL 2014 SP2 CU14 or later version (2016, 2017 or 2019) Q4486935 KB4486935 October 23, 2020
- 4486932 FIX: Users are incorrectly permitted to create incremental statistics on nonclustered indexes which are not aligned to the base table in SQL Server 2016 and 2017 Q4486932 KB4486932 October 23, 2020
- 4486852 FIX: Access violation when you run a query that contains a batch-mode hash join on Clustered Columnstore Index table in SQL Server 2016 Q4486852 KB4486852 October 23, 2020
- 4483571 FIX: Possible assertion failure when a cross-database transaction involving an Availability Group database is committed from a SQL Server trigger Q4483571 KB4483571 October 23, 2020
- 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server Q4483427 KB4483427 October 23, 2020
- 4480651 Improvement: Merge operation will consider the number of deleted rows in the rowgroup in SQL Server 2016 and 2017 Q4480651 KB4480651 October 23, 2020
- 4480650 FIX: sys.fn_hadr_backup_is_preferred_replica returns TRUE for more than one secondary replica even if the priority values are identical in SQL Server 2016 and 2017 Q4480650 KB4480650 October 23, 2020
- 4480641 FIX: Columnstore Index build request may time out after 25 seconds though the memory grant time-out is configured in SQL Server 2016 or 2017 Q4480641 KB4480641 October 23, 2020
- 4480640 FIX: Server crashes when you cancel DBCC CHECKDB against a large database in SQL Server 2016 Q4480640 KB4480640 October 23, 2020
- 4480635 FIX: High CPU usage when there are many batch requests in SQL Server Q4480635 KB4480635 October 23, 2020
- 4469908 FIX: Error 3961 occurs when you use Application roles for the second time in read-only secondary replicas in SQL Server 2016 AG Q4469908 KB4469908 October 23, 2020
- 4468101 Improvement: Optional replacement for "String or binary data would be truncated" message with extended information in SQL Server 2016 and 2017 Q4468101 KB4468101 October 23, 2020
- 4467058 FIX: Query plans are different on clone database created by DBCC CLONEDATABASE and its original database in SQL Server 2014, 2016 and 2017 Q4467058 KB4467058 October 23, 2020
- 4467006 FIX: The schedule changes to "Report-specific schedule" when you enable "Create cache snapshots on a schedule" for the report in SSRS 2016 Q4467006 KB4467006 October 23, 2020
- 4466107 FIX: Encryption scan task triggered upon the startup of a database may be canceled in SQL Server 2016 Q4466107 KB4466107 October 23, 2020
- 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 October 23, 2020
- 4131193 Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016 Q4131193 KB4131193 October 23, 2020
- 4073393 FIX: "The data area passed to a system call is too small" error when you start a Desktop Bridge application on a SQL Server Q4073393 KB4073393 October 23, 2020
- 4016657 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 SP1 Q4016657 KB4016657 October 23, 2020
- 4016655 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 Q4016655 KB4016655 October 23, 2020
- 4010990 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases Q4010990 KB4010990 October 23, 2020
- 4010710 FIX: Memory leak when you run a query that you don’t have sufficient permissions for in SQL Server 2014 or 2016 Q4010710 KB4010710 October 23, 2020
- 4010162 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure Q4010162 KB4010162 October 23, 2020
- 4010159 FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 Q4010159 KB4010159 October 23, 2020
- 4009823 FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014 or 2016 Q4009823 KB4009823 October 23, 2020
- 4009624 FIX: Audit calls trigger asserts when you create or drop external tables in SQL Server 2016 Q4009624 KB4009624 October 23, 2020
- 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 October 23, 2020
- 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 October 20, 2020
- 10179 Troubleshooting SQL Server AlwaysOn Issues Q10179 KB10179 October 3, 2020
- 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 2020
- 4046801 “Cannot apply value 'null' to property ServerInstance" error when looking at subscription properties in SQL Server 2017 or 2016 Q4046801 KB4046801 September 29, 2020
- 4010261 SQL Server and Azure SQL Database improvements in handling some data types and uncommon operations Q4010261 KB4010261 September 29, 2020
- 3200464 Error when you attach a CDC-enabled database to an instance of SQL Server 2016 or SQL Server 2017 on Windows Q3200464 KB3200464 September 29, 2020
- 3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later Q3189675 KB3189675 September 29, 2020
- 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 September 29, 2020
- 2295405 SQL Server service crashes when you run an Oracle linked server query Q2295405 KB2295405 August 18, 2020
- 4575943 Improvement: SQL Server 2016 setup changes to support runtime upgrade for R Services Q4575943 KB4575943 August 7, 2020
- 945934 How to register Microsoft Filter Pack IFilters with SQL Server Q945934 KB945934 April 30, 2020
- 2618570 "0x80770006" and "3201" errors after you install an instance of SQL Server 2008 R2 and later versions Q2618570 KB2618570 April 14, 2020
- 2681562 Using SQL Server in Windows 8 and later versions of Windows operating system Q2681562 KB2681562 April 9, 2020
- 956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment Q956893 KB956893 March 31, 2020
- 4541550 FIX: UDF Scalar-Valued-Function may take longer and consume more CPU in SQL Server 2016 Q4541550 KB4541550 February 25, 2020
- 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020