kbupdate.info ›
Daily Updated!
SQL Server 2014 articles, fixes and updates - Year 2020
Daily Updated!
chronological list: 2023 | 2022 | 2021/9 8 6 4 3 2 1 | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2014
alphabetical list: A B C D E F H I J K 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 2014 that have been released in Year 2020. The list is daily updated.
- 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
- 956032 Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files" Q956032 KB956032 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
- 971268 "Evaluation period has expired" error message when working with SQL server Q971268 KB971268 December 1, 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
- 3005016 Orphaned XA transactions when you connect to SQL Server by using JDBC Driver for SQL Server Q3005016 KB3005016 November 8, 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
- 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server Q914288 KB914288 November 8, 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
- 4512011 FIX: Fix prefast warnings (62100) in Sql\Sqlrepl\xpreplclr.net\ReplCmdDataReader.cs to prevent SQL injection attacks Q4512011 KB4512011 October 23, 2020
- 4511868 FIX: Error 409 occurs when you back up databases by using BackuptoURL Q4511868 KB4511868 October 23, 2020
- 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 23, 2020
- 4511750 FIX: SQL batch performance drops when you enable "Force Encryption" in SQL Server 2014 Q4511750 KB4511750 October 23, 2020
- 4511743 FIX: High CPU usage on Primary when SQL Service on Readable Secondary is turned off in Availability Group in SQL Server 2014 Q4511743 KB4511743 October 23, 2020
- 4511608 FIX: Full-text search fails to remove files from \FTDATA\FilterData subfolder in SQL Server 2014 Q4511608 KB4511608 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
- 4510122 FIX: An exception error occurs when you acquire a session lock during a logout audit event in SQL Server 2014 Q4510122 KB4510122 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
- 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
- 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 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
- 4492379 FIX: CDC source preview fails with "The given key was not present in the dictionary" in SQL Server 2014 Q4492379 KB4492379 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
- 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
- 4487957 FIX: Power BI Desktop queries may fail with error code 3238002710 in SSAS 2014 Q4487957 KB4487957 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
- 4480635 FIX: High CPU usage when there are many batch requests in SQL Server Q4480635 KB4480635 October 23, 2020
- 4471974 FIX: Stored procedure output parameters may return incorrectly when called through RPC with PREPARE option in SQL Server 2014 Q4471974 KB4471974 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
- 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 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
- 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
- 4010500 FIX: Sys.dm_tran_commit_table DMV and CHANGETABLE function return incorrect results if SQL Server shuts down unexpectedly Q4010500 KB4010500 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
- 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
- 3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later Q3189675 KB3189675 September 29, 2020
- 3049257 Error 3989 or 3988 when a distributed query that joins multiple tables is hosted by remote instances of SQL Server Q3049257 KB3049257 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
- 2722715 Support for the leap second Q2722715 KB2722715 May 28, 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
- 944837 Description of the Replay Markup Language (RML) Utilities for SQL Server Q944837 KB944837 April 10, 2020
- 2681562 Using SQL Server in Windows 8 and later versions of Windows operating system Q2681562 KB2681562 April 9, 2020
- 917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database Q917047 KB917047 April 9, 2020
- 956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment Q956893 KB956893 March 31, 2020
- 2154845 Recommendations to reduce allocation contention in SQL Server tempdb database Q2154845 KB2154845 March 27, 2020
- 3120595 FIX: Column data may be deleted when you update another variable-length column in a table of a database upgraded from SQL Server 2005 Q3120595 KB3120595 February 20, 2020
- 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020