SQL Server 2014 articles, fixes and updates - Year 2019

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 2019. The list is daily updated.

• 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 24, 2019
• 4534430 Fail to backup transaction log after TDE Certificate/Key rotation Q4534430 KB4534430 December 19, 2019
• 3196320 SQL query times out or console slow on certain Configuration Manager database queries Q3196320 KB3196320 December 18, 2019
• 3210239 Interoperability of Columnstore indexes with large page memory model in SQL Server Q3210239 KB3210239 December 15, 2019
• 263889 How to troubleshoot blocking caused by compile locks Q263889 KB263889 December 11, 2019
• 4503417 FIX: Assertion dump occurs when you select a view on a linked server in SQL Server 2017, 2016, or 2014 Q4503417 KB4503417 December 10, 2019
• 4533057 MDX query fails with "Query optimizer generated too many subcubes" in SSAS multidimensional instance Q4533057 KB4533057 December 5, 2019
• 3189645 FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139 Q3189645 KB3189645 November 20, 2019
• 2981764 FIX: Cannot create indexed view on a clustered columnstore index and BCP on the table fails in SQL Server 2014 Q2981764 KB2981764 November 20, 2019
• 3113071 FIX: SubscriptionStreams parameter is ignored by the Distribution Agent when you use transactional replication in SQL Server 2014 Q3113071 KB3113071 November 19, 2019
• 3061685 FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014 Q3061685 KB3061685 November 19, 2019
• 3013861 FIX: Upgrade wizard appears again when you reopen the SSIS 2014 solution with upgraded SSIS packages Q3013861 KB3013861 November 19, 2019
• 2997392 FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 or 2014 Q2997392 KB2997392 November 19, 2019
• 2968418 FIX: "Non-yielding scheduler" error when you insert or update many rows in one transaction in SQL Server 2014 Q2968418 KB2968418 November 19, 2019
• 2967594 FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server Q2967594 KB2967594 November 19, 2019
• 2966096 FIX: Access violation when you insert data into a table that has a clustered columnstore index in SQL Server 2014 Q2966096 KB2966096 November 19, 2019
• 2959342 FIX: Data-driven subscription can't be created when the driving query takes longer than 30 seconds to execute in SQL Server Q2959342 KB2959342 November 19, 2019
• 2958191 FIX: TRACK_CAUSALITY causes access violations for batch completed event or RPC completed event in SQL Server 2014 Q2958191 KB2958191 November 19, 2019
• 2957768 FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012 or SSRS 2014 Q2957768 KB2957768 November 19, 2019
• 2956619 FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system Q2956619 KB2956619 November 19, 2019
• 2931241 FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012 or SQL Server 2014 Q2931241 KB2931241 November 19, 2019
• 2733630 The merge agent may fail during merge replication synchronization in SQL Server Q2733630 KB2733630 November 14, 2019
• 2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server Q2729953 KB2729953 November 14, 2019
• 2711671 MDS Validate Version command fails with a server error in SQL Server 2012 and SQL Server 2014 Q2711671 KB2711671 November 14, 2019
• 918483 How to reduce paging of buffer pool memory in SQL Server Q918483 KB918483 November 14, 2019
• 835185 Microsoft Windows Failover cluster resource dependencies in SQL Server Q835185 KB835185 November 14, 2019
• 2722715 Support for the leap second Q2722715 KB2722715 November 12, 2019
• 4470220 Cumulative Update 1 for SQL Server 2014 SP3 Q4470220 KB4470220 November 10, 2019
• 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 November 3, 2019
• 3177838 How to use DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server 2014 SP2 and SQL Server 2016 SP1 Q3177838 KB3177838 October 28, 2019
• 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 8, 2019
• 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 October 8, 2019
• 4505422 Description of the security update for SQL Server 2014 SP3 CU3: July 9, 2019 Q4505422 KB4505422 September 25, 2019
• 4505419 Description of the security update for SQL Server 2014 SP2 CU17: July 9, 2019 Q4505419 KB4505419 September 25, 2019
• 4505218 Description of the security update for SQL Server 2014 SP3 GDR: July 9, 2019 Q4505218 KB4505218 September 25, 2019
• 4505217 Description of the security update for SQL Server 2014 SP2 GDR: July 9, 2019 Q4505217 KB4505217 September 25, 2019
• 4511868 FIX: Error 409 occurs when you back up databases by using BackuptoURL Q4511868 KB4511868 August 2, 2019
• 4512016 FIX: Syscommittab cleanup causes a lock escalation that will block the syscommittab flush in SQL Server 2014, 2016 and 2017 Q4512016 KB4512016 August 1, 2019
• 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 August 1, 2019
• 4506023 FIX: Geocentric Datum of Australia 2020 is added to SQL Server 2014, 2016 and 2017 Q4506023 KB4506023 August 1, 2019
• 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 August 1, 2019
• 4489150 FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014, 2016 and 2017 Q4489150 KB4489150 August 1, 2019
• 4512011 FIX: Fix prefast warnings (62100) in Sql\Sqlrepl\xpreplclr.net\ReplCmdDataReader.cs to prevent SQL injection attacks Q4512011 KB4512011 July 29, 2019
• 4511771 FIX: Full-Text search auto populate stops when Availability Group goes offline in SQL Server 2014 Q4511771 KB4511771 July 29, 2019
• 4511750 FIX: SQL batch performance drops when you enable "Force Encryption" in SQL Server 2014 Q4511750 KB4511750 July 29, 2019
• 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 July 29, 2019
• 4511608 FIX: Full-text search fails to remove files from \FTDATA\FilterData subfolder in SQL Server 2014 Q4511608 KB4511608 July 29, 2019
• 4510122 FIX: An exception error occurs when you acquire a session lock during a logout audit event in SQL Server 2014 Q4510122 KB4510122 July 29, 2019
• 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 July 29, 2019
• 4500181 Cumulative Update 4 for SQL Server 2014 SP3 Q4500181 KB4500181 July 29, 2019
• 4500180 Cumulative Update 18 for SQL Server 2014 SP2 Q4500180 KB4500180 July 29, 2019
• 4497230 FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014, 2016 and 2017 Q4497230 KB4497230 July 29, 2019
• 4490140 FIX: Stack Dump occurs in the change tracking cleanup process in SQL Server 2014, 2016 and 2017 Q4490140 KB4490140 July 29, 2019
• 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server Q4483427 KB4483427 July 29, 2019
• 4469942 FIX: Sharing violation when the “sp_cycle_agent_errorlog” stored procedure is run in SQL Server 2016 Q4469942 KB4469942 July 29, 2019
• 2936603 SQL Server 2014 build versions Q2936603 KB2936603 July 29, 2019
• 2009160 High CPU use occurs in your queries on SQL Server Q2009160 KB2009160 July 23, 2019
• 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 June 22, 2019
• 2806535 Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server Q2806535 KB2806535 June 11, 2019
• 4504104 Non-component VSS backups such as Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs Q4504104 KB4504104 June 5, 2019
• 2922898 "Error 9002. The transaction log for database is full due to 'AVAILABILITY_REPLICA'" error message in SQL Server Q2922898 KB2922898 June 3, 2019
• 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 2014 and 2017 server Q4073393 KB4073393 May 27, 2019
• 4499231 FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014, 2016 and 2017 Q4499231 KB4499231 May 23, 2019
• 4502458 RESTORE VERIFYONLY logs CREATE DATABASE in a server audit specification that uses DATABASE_CHANGE_GROUP in SQL Server Q4502458 KB4502458 May 15, 2019
• 4502457 Error when Database Mail fails to send message Q4502457 KB4502457 May 15, 2019
• 957826 Where to find information about the latest SQL Server builds Q957826 KB957826 May 2, 2019
• 4492379 FIX: CDC source preview fails with "The given key was not present in the dictionary" in SQL Server 2014 Q4492379 KB4492379 April 27, 2019
• 4019099 Cumulative Update 13 for SQL Server 2014 SP1 Q4019099 KB4019099 April 17, 2019
• 4491540 Cumulative Update 17 for SQL Server 2014 SP2 Q4491540 KB4491540 April 16, 2019
• 4491539 Cumulative Update 3 for SQL Server 2014 SP3 Q4491539 KB4491539 April 16, 2019
• 4467058 Query plans are different on clone database and its original database Q4467058 KB4467058 April 16, 2019
• 3083381 Duplicate key rows from the sys.syscommittab table in SQL Server Q3083381 KB3083381 April 11, 2019
• 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 April 4, 2019
• 4488809 FIX: Assertion occurs when a parallel query deletes from a Filestream table in SQL Server 2014, 2016 and 2017 Q4488809 KB4488809 March 25, 2019
• 4480647 Update adds improvements and fixes issues when you use an Oracle RAC environment in SQL Server Q4480647 KB4480647 March 25, 2019
• 4475322 FIX: "Non-yielding" error occurs when there is a heavy use of prepared statements in SQL Server 2014, 2016 and 2017 Q4475322 KB4475322 March 25, 2019
• 4469268 I/O error on a BPE file causes buffer time-out in SQL Server Q4469268 KB4469268 March 25, 2019
• 3191296 Update extends the Trace extended event with security protocol handshake information in SQL Server Q3191296 KB3191296 March 21, 2019
• 4338890 SQL Server appears unresponsive and "Non-yielding Scheduler" error occurs Q4338890 KB4338890 March 20, 2019
• 4463320 Backing up SQL Server databases to Azure storage intermittently fails Q4463320 KB4463320 March 19, 2019
• 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Q4053693 KB4053693 March 14, 2019
• 2801413 Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level Q2801413 KB2801413 March 14, 2019
• 4459860 Cumulative Update 14 for SQL Server 2014 Q4459860 KB4459860 March 7, 2019
• 4456287 Cumulative Update 13 for SQL Server 2014 SP2 Q4456287 KB4456287 March 7, 2019
• 4022619 SQL Server 2014 Service Pack 3 release information Q4022619 KB4022619 March 7, 2019
• 2958069 How to obtain the latest service pack for SQL Server 2014 Q2958069 KB2958069 March 4, 2019
• 4480635 FIX: High CPU usage when there are many batch requests in SQL Server Q4480635 KB4480635 February 27, 2019
• 4482960 Cumulative Update 2 for SQL Server 2014 SP3 Q4482960 KB4482960 February 25, 2019
• 2681562 Using SQL Server in Windows 8 and later versions of Windows operating system Q2681562 KB2681562 February 21, 2019
• 4487957 FIX: Power BI Desktop queries may fail with error code 3238002710 in SSAS 2014 Q4487957 KB4487957 February 19, 2019
• 4482967 Cumulative Update 16 for SQL Server 2014 SP2 Q4482967 KB4482967 February 19, 2019
• 4471974 FIX: Stored procedure output parameters may return incorrectly when called through RPC with PREPARE option in SQL Server 2014 Q4471974 KB4471974 February 19, 2019
• 4057280 High CPU use when large index used in query on memory optimized table Q4057280 KB4057280 February 19, 2019
• 2019698 How to schedule and automate backups of SQL Server databases in SQL Server Express Q2019698 KB2019698 February 17, 2019
• 2000257 SQL Server installation fails if the Setup account doesn't have certain user rights Q2000257 KB2000257 February 17, 2019
• 4488253 Configure MSOLAP data provider for Excel to connect to Analysis Services Q4488253 KB4488253 January 30, 2019
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 28, 2019
• 4488254 Performance degradation when many SchemaMgr Store entries in SQL Server Q4488254 KB4488254 January 24, 2019
• 4480648 FIX: ObjectPropertyEx row count wrong if partitions in database object Q4480648 KB4480648 January 23, 2019
• 4480639 FIX: DBCC CHECKDB crashes SQL Server if database partition corrupted Q4480639 KB4480639 January 23, 2019
• 4479283 FIX: SQL Server installation fails if remote cluster node unreachable Q4479283 KB4479283 January 23, 2019
• 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 23, 2019
• 4460112 Access violation occurs when you run a query that uses XML data type Q4460112 KB4460112 January 23, 2019
• 4346803 Error when you run sp_send_dbmail that has comma in sender email and name Q4346803 KB4346803 January 23, 2019
• 4090032 Memory exhausted when run PBI report that executes DAX query on SSAS Q4090032 KB4090032 January 23, 2019
• 2987585 Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012 Q2987585 KB2987585 January 21, 2019
• 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 January 10, 2019