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 25, 2019
• 4534430 Msg 33111 error after SQL Server TDE certificate or 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 16, 2019
• 263889 How to troubleshoot blocking caused by compile locks Q263889 KB263889 December 12, 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 11, 2019
• 4533057 "Query optimizer generated too many subcubes" error and MDX query fails 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
• 3113071 FIX: SubscriptionStreams parameter is ignored by the Distribution Agent when you use transactional replication in SQL Server 2014 Q3113071 KB3113071 November 20, 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 20, 2019
• 3013861 FIX: Upgrade wizard appears again when you reopen the SSIS 2014 solution with upgraded SSIS packages Q3013861 KB3013861 November 20, 2019
• 2997392 FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 or 2014 Q2997392 KB2997392 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
• 2968418 FIX: "Non-yielding scheduler" error when you insert or update many rows in one transaction in SQL Server 2014 Q2968418 KB2968418 November 20, 2019
• 2967594 FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server Q2967594 KB2967594 November 20, 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 20, 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 20, 2019
• 2958191 FIX: TRACK_CAUSALITY causes access violations for batch completed event or RPC completed event in SQL Server 2014 Q2958191 KB2958191 November 20, 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 20, 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 20, 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 20, 2019
• 2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server Q2729953 KB2729953 November 15, 2019
• 2711671 MDS Validate Version command fails with a server error in SQL Server 2012 and SQL Server 2014 Q2711671 KB2711671 November 15, 2019
• 918483 How to reduce paging of buffer pool memory in SQL Server Q918483 KB918483 November 15, 2019
• 2733630 The merge agent may fail during merge replication synchronization in SQL Server Q2733630 KB2733630 November 14, 2019
• 835185 Microsoft Windows Failover cluster resource dependencies in SQL Server Q835185 KB835185 November 14, 2019
• 4470220 Cumulative Update 1 for SQL Server 2014 SP3 Q4470220 KB4470220 November 11, 2019
• 3177838 How to use DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server 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
• 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
• 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
• 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 2014 and 2016 Q4469942 KB4469942 July 29, 2019
• 2936603 SQL Server 2014 build versions Q2936603 KB2936603 July 29, 2019
• 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 July 23, 2019
• 2806535 Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server Q2806535 KB2806535 June 12, 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 6, 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 Q4073393 KB4073393 May 28, 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 24, 2019
• 4502458 FIX: Running RESTORE VERIFYONLY logs a CREATE DATABASE event in a server audit specification that uses DATABASE_CHANGE_GROUP in SQL Server Q4502458 KB4502458 May 15, 2019
• 4502457 "The transaction not longer valid" error when Database Mail fails to send a message in SQL Server 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 28, 2019
• 4019099 Cumulative Update 13 for SQL Server 2014 SP1 Q4019099 KB4019099 April 18, 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 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 April 16, 2019
• 3083381 Duplicate key rows from the sys.syscommittab table in SQL Server Q3083381 KB3083381 April 12, 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 FIX: I/O error on a BPE file causes buffer time-out in SQL Server Q4469268 KB4469268 March 25, 2019
• 4338890 FIX: "Non-yielding Scheduler" error and SQL Server appears unresponsive in SQL Server 2014, 2016 and 2017 Q4338890 KB4338890 March 21, 2019
• 4463320 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2014, 2016 and 2017 Q4463320 KB4463320 March 20, 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 SP2 Q4459860 KB4459860 March 8, 2019
• 4456287 Cumulative Update 13 for SQL Server 2014 SP2 Q4456287 KB4456287 March 8, 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 5, 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 26, 2019
• 4487957 FIX: Power BI Desktop queries may fail with error code 3238002710 in SSAS 2014 Q4487957 KB4487957 February 20, 2019
• 4482967 Cumulative Update 16 for SQL Server 2014 SP2 Q4482967 KB4482967 February 20, 2019
• 4471974 FIX: Stored procedure output parameters may return incorrectly when called through RPC with PREPARE option in SQL Server 2014 Q4471974 KB4471974 February 20, 2019
• 4057280 FIX: High CPU use when large index is used in a query on a memory-optimized table in SQL Server Q4057280 KB4057280 February 20, 2019
• 2019698 How to schedule and automate backups of SQL Server databases in SQL Server Express Q2019698 KB2019698 February 18, 2019
• 2000257 SQL Server installation fails if the Setup account doesn't have certain user rights Q2000257 KB2000257 February 18, 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 29, 2019
• 4488254 Many CMEMTHREAD waits when many SchemaMgr Store entries exist in SQL Server Q4488254 KB4488254 January 24, 2019
• 4480648 FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object Q4480648 KB4480648 January 23, 2019
• 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition Q4480639 KB4480639 January 23, 2019
• 4479283 FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster 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 FIX: Access violation when you run a query that uses the XML data type in SQL Server 2014, 2016 and 2017 Q4460112 KB4460112 January 23, 2019
• 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 23, 2019
• 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 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 22, 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