SQL Server 2016 articles, fixes and updates - Year 2018

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

• 4470991 Access violation when you run a granular audit policy for DML in SQL Server Q4470991 KB4470991 December 18, 2018
• 4467119 AV when you query data from view on table with columnstore index Q4467119 KB4467119 December 18, 2018
• 4465443 Modification_counter incorrect value when partitions are merged Q4465443 KB4465443 December 18, 2018
• 4459522 Slow query performs when NULL filters on Partition key with default CE Q4459522 KB4459522 December 18, 2018
• 4458157 Assertion error occurs when you use sys.dm_exec_query_statistics_xml Q4458157 KB4458157 December 18, 2018
• 4340986 FIX: Access violation in cross data center failover if you use Always On Availability Groups in SQL Server Q4340986 KB4340986 December 18, 2018
• 4470546 SSAS fails in Multidimensional dimension that has Proactive Caching enabled Q4470546 KB4470546 December 11, 2018
• 4469993 Supported SQL Server database compatibility level for SharePoint Server 2016 installations Q4469993 KB4469993 November 30, 2018
• 4469857 Inner error details will not be displayed to remote machine Q4469857 KB4469857 November 13, 2018
• 4469815 Cannot add data to a new users attribute in an MDS database in SQL Server Q4469815 KB4469815 November 13, 2018
• 4469539 DefaultLanguage.LCID property changes for partially contained In-Memory OLTP database Q4469539 KB4469539 November 13, 2018
• 4468869 FIX: Relationships not working correctly on synchronized tabular database Q4468869 KB4468869 November 13, 2018
• 4468868 Server freezes when you send create session to call custom assembly in SSAS Q4468868 KB4468868 November 13, 2018
• 4468322 Assertion occurs when using parallel redo in a secondary replica Q4468322 KB4468322 November 13, 2018
• 4465747 FIX: Snapshot Agent fails when publishing many tables using snapshot or transactional replication Q4465747 KB4465747 November 13, 2018
• 4465517 "102" and "incorrect syntax near ‘sp_MS’" errors when you create peer-to-peer replication in SQL Server Q4465517 KB4465517 November 13, 2018
• 4465511 "INSERT EXEC failed because the stored procedure altered the schema of the target table" error in SQL Server 2016 Q4465511 KB4465511 November 13, 2018
• 4465476 FIX: Errors when changing filters in Excel or PBI reports after model is updated in SSAS Q4465476 KB4465476 November 13, 2018
• 4462426 Error when changing "Name" to any other value in SQL Server MDS Add-in for Excel Q4462426 KB4462426 November 13, 2018
• 2964518 Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads Q2964518 KB2964518 November 13, 2018
• 327518 The Microsoft Support Policy for Clustered Configurations of SQL Server with Windows Server Q327518 KB327518 November 12, 2018
• 4092075 Adds Service Broker support for DBCC CLONEDATABASE in SQL Server Q4092075 KB4092075 November 5, 2018
• 2002606 OS errors 1450 and 665 are reported for database data files Q2002606 KB2002606 October 2, 2018
• 4459682 FIX: Duplicate week entry displayed in SSRS 2016 mobile report if the week starts on Monday Q4459682 KB4459682 September 20, 2018
• 4456962 Add spill information of batch-mode operators in SQL Server Q4456962 KB4456962 September 20, 2018
• 4456163 No extension if downloading an SSRS report whose name is in Russian Q4456163 KB4456163 September 20, 2018
• 4294660 FIX: SSAS stops responding when you run MDX queries and DirectQuery mode is enabled in SQL Server Q4294660 KB4294660 September 20, 2018
• 4135045 FIX: DROP_ASYMMETRIC_KEY causes SQL Server crash if rolled back from trigger Q4135045 KB4135045 September 20, 2018
• 3171174 Add error codes to diagnostics information for SSIS 2016 package execution failures Q3171174 KB3171174 September 20, 2018
• 4340426 FIX: The Excel Add-in still appears on the MDS home page when the option is set to “No” in MDS Configuration Manager Q4340426 KB4340426 August 27, 2018
• 4337554 FIX: SSAS service crashes when you use the “Connect live” option in Power BI Desktop Q4337554 KB4337554 August 15, 2018
• 4456140 Redo delay on secondary when you commit transaction on XTP of primary Q4456140 KB4456140 August 6, 2018
• 4230730 Latch timeout when you run online index rebuild or merge statement Q4230730 KB4230730 July 20, 2018
• 4341253 sys.dm_db_log_stats and sys.dm_db_log_info return incorrect values Q4341253 KB4341253 July 18, 2018
• 4133164 FIX: Error when a SQL Server Agent job runs a PowerShell command to enumerate permissions of the database Q4133164 KB4133164 July 18, 2018
• 4341356 Improvement: Always On Availability Groups automatically seed to all replicas when you add a new database in SQL Server Q4341356 KB4341356 July 16, 2018
• 4341233 Error 7320 when inserting dates after 2038-01-20 or before 1970-01-01 into Hive ORC file format table Q4341233 KB4341233 July 16, 2018
• 4340342 FIX: Query on a secondary replica takes two times as long as on a primary replica in SQL Server Q4340342 KB4340342 July 16, 2018
• 4134541 FIX: Error in MDS Add-in for Excel when using German Excel in SQL Server Q4134541 KB4134541 June 27, 2018
• 4162814 FIX: Internal exception access violation, SSAS server stops responding Q4162814 KB4162814 June 21, 2018
• 4134175 FIX: Processing cube with many partitions generates many concurrent data source connections in SSAS Q4134175 KB4134175 June 21, 2018
• 4293839 FIX: TDE database goes offline during log flush if you lose connection to the EKM provider in SQL Server Q4293839 KB4293839 June 18, 2018
• 4047327 Non-applicable SQL Server CUs are listed in WSUS, MU, or ConfMgr Q4047327 KB4047327 June 1, 2018
• 4034603 System Center Operations Manager can’t monitor SQL Server Analytics Platform System appliance Q4034603 KB4034603 June 1, 2018
• 4023373 Event ID 17141 is logged when SQL Server does not come online in Windows Failover Clustering Q4023373 KB4023373 June 1, 2018
• 4230306 FIX: Restore of TDE-compressed backup via VDI client is unsuccessful Q4230306 KB4230306 May 30, 2018
• 4132267 FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode Q4132267 KB4132267 May 30, 2018
• 4098762 FIX: Hidden parameters included in reports when Browser role used in SSRS 2016 Q4098762 KB4098762 May 30, 2018
• 4316959 Warning message that contains “HkHostBackupGetCheckpointFileInfoV2” and “1000016” is logged in the SQL Server error log Q4316959 KB4316959 May 29, 2018
• 4230836 Application event log error code 1642 even though the SQL Server update was applied successfully Q4230836 KB4230836 May 14, 2018
• 4092066 Support to enable replication when database collation uses '_SC' collation Q4092066 KB4092066 April 24, 2018
• 4089509 FIX: Access Violation when you use QDS and specify a query plan to resolve a performance regression Q4089509 KB4089509 April 24, 2018
• 4092046 Can't restart SQL Server after using ALTER DATABASE ADD FILE or ADD LOG Q4092046 KB4092046 April 23, 2018
• 4075158 FIX: Booleans localized incorrectly in report parameters in SSRS 2016 (SharePoint mode) Q4075158 KB4075158 April 23, 2018
• 4046902 FIX: "TempDB file size exceeds 1024 MB" error when you try to set the initial size for a TempDB file to a value greater than 1,024 MB Q4046902 KB4046902 April 23, 2018
• 4045795 Thread pool exhaustion and CMEMTHREAD contention in AAG Q4045795 KB4045795 April 23, 2018
• 4041817 Update enables XML Showplans to provide query optimization statistics used in SQL Server Q4041817 KB4041817 April 23, 2018
• 4039846 TRY…CATCH block rolls back many transactions in in-memory OLTP error handling scenarios Q4039846 KB4039846 April 23, 2018
• 4090025 FIX: Random masking does not mask BIGINT values correctly in SQL Server Q4090025 KB4090025 April 18, 2018
• 4077708 FIX: Assert in "HadrRefcountedObject::Release" when replica configured for manual seeding in SQL Server Q4077708 KB4077708 April 18, 2018
• 4100766 "#N/A" returns when you run a multi-subselect query in SQL Server Analysis Services Q4100766 KB4100766 April 12, 2018
• 4103833 FIX: Q4103833 KB4103833 April 3, 2018
• 3210540 "Msg 105005" error occurs with CETAS operation to Azure blob storage in SQL Server Parallel Data Warehouse Q3210540 KB3210540 March 30, 2018
• 4019671 FIX: Severe error when you create a spatial index by using the GEOMETRY_GRID or GEOGRAPHY_GRID option in SQL Server Q4019671 KB4019671 March 25, 2018
• 4090137 FIX: KPI trend line not correct when shared dataset cache updated in SQL Server Q4090137 KB4090137 March 23, 2018
• 4089171 FIX: PolyBase Engine startup crash if performance counters missing from Windows Performance Monitor Q4089171 KB4089171 March 23, 2018
• 4089095 FIX: Bad MDX query results after restoring tabular db in SQL Server Q4089095 KB4089095 March 23, 2018
• 4074696 FIX: Drillthrough operation fails and returns an error for row-level non-administrators in SSAS 2016 (Tabular model) Q4074696 KB4074696 March 19, 2018
• 2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space Q2033238 KB2033238 March 5, 2018
• 4052121 FIX: Access violation for DMV queries run against a distributed availability group in SQL Server Q4052121 KB4052121 February 20, 2018
• 4040934 FIX: SQL Server Integration Service packages randomly hang if custom logging is enabled Q4040934 KB4040934 February 20, 2018
• 2015100 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q2015100 KB2015100 February 14, 2018
• 4088924 Disk space exhaustion during the rollback of a failed processing job causes SSAS to crash Q4088924 KB4088924 February 12, 2018
• 4082888 FIX: Error occurs when you install SQL Server 2016 on a Cluster Shared Volume disk Q4082888 KB4082888 February 12, 2018
• 4045273 Full-text indexes stop populating for 30 minutes in SQL Server Q4045273 KB4045273 February 2, 2018