SQL Server 2016 articles, fixes and updates - Year 2017

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

• 4052132 FIX: Non-yielding scheduler error when using SQL Server Query Store in SQL Server Q4052132 KB4052132 November 22, 2017
• 4043459 FIX: Remote instance of SQL Server crashes when a stored procedure bulk loads an incomplete data file into a temporary table Q4043459 KB4043459 October 24, 2017
• 4043103 FIX: Load data from staging tables takes a much longer time to finish when recursive hierarchy is used in Master Data Services Q4043103 KB4043103 October 24, 2017
• 4022594 FIX: Incorrect MDX query results if a table cross join is run on a table hierarchy member in SSAS Q4022594 KB4022594 October 24, 2017
• 4021994 FIX: SSAS crashes when a measure is added that refers to null values in Power BI Q4021994 KB4021994 October 24, 2017
• 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Q4017827 KB4017827 October 24, 2017
• 3212541 FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase Q3212541 KB3212541 October 24, 2017
• 4033835 Access violations and memory dump files when you use XEvent session with sqlos.wait_info event in SQL Server Q4033835 KB4033835 October 9, 2017
• 3212023 Performance degradation when you upgrade from database compatibility level 120 to 130 in SQL Server 2016 or in SQL Server 2017 on Windows Q3212023 KB3212023 October 9, 2017
• 3204545 The .NET Framework 4.6.2 client driver for "Always Encrypted" intermittently fails during row decryption Q3204545 KB3204545 October 9, 2017
• 3196535 Description of the Update Cache folder in SQL Server Q3196535 KB3196535 October 9, 2017
• 3195161 Defragmenting SQL Server database disk drives Q3195161 KB3195161 October 9, 2017
• 3191316 Words that have leading decimal points are not returned by an English word breaker in SQL Server Q3191316 KB3191316 October 9, 2017
• 3163368 Max_Queue_Readers property is ignored when you try to limit activation tasks in Service Broker Q3163368 KB3163368 October 9, 2017
• 3092936 Increased CPU usage when you access a SQL Server FileTable share from Windows Explorer Q3092936 KB3092936 October 9, 2017
• 2871474 SQL Transaction log grows when you use Change Data Capture for Oracle by Attunity Q2871474 KB2871474 October 9, 2017
• 2754171 Controlling Autostat (AUTO_UPDATE_STATISTICS) behavior in SQL Server Q2754171 KB2754171 October 9, 2017
• 918992 How to transfer logins and passwords between instances of SQL Server Q918992 KB918992 October 9, 2017
• 231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Q231619 KB231619 October 9, 2017
• 224071 Troubleshooting SQL Server backup and restore operations Q224071 KB224071 October 9, 2017
• 3108537 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server Q3108537 KB3108537 September 18, 2017
• 4040549 Query execution takes significantly longer on SQL Server Always On secondary replicas Q4040549 KB4040549 September 7, 2017
• 4038458 No results for XMLA script query for properties/members of a Dimension Hierarchy in Server 2016 Analysis Services Q4038458 KB4038458 August 25, 2017
• 4038454 IDENTITY or SEQUENCE values jumps after you restart SQL Server Q4038454 KB4038454 August 23, 2017
• 4038459 Informatica loads fail with connection errors in SQL Server Parallel Data Warehouse Q4038459 KB4038459 August 22, 2017
• 4024868 FIX: Assertion failure when backing up large TDE encrypted database in SQL Server Q4024868 KB4024868 August 8, 2017
• 4024126 FIX: Access violation in sqllang.dll after upgrading to SQL Server 2016 SP1 Q4024126 KB4024126 August 8, 2017
• 4024125 FIX: After upgrade to SQL Server 2016 SP1, an access violation occurs in sqlmin.dll when querying against a Columnstore index Q4024125 KB4024125 August 8, 2017
• 4019048 FIX: SSAS crashes when you retrieve KPIs as hidden members by using schema rowsets in SQL Server Q4019048 KB4019048 August 8, 2017
• 3185365 SQL Server 2016 Agent fails to start or “Failed to retrieve data” error when you try to read error log from SSMS 2016 Q3185365 KB3185365 June 20, 2017
• 4019988 FIX: Access violation and SSAS 2016 crashes when many partitions and their aggregations or indexes are processed concurrently Q4019988 KB4019988 May 15, 2017
• 4019097 FIX: Error 608 when a stored procedure that inserts rows into a temporary table that has a spatial index is run in SQL Server Q4019097 KB4019097 May 15, 2017
• 4018741 FIX: MDX query returns an error in SQL Server Analysis Service if the dimension table contains members that do not exist in the fact table Q4018741 KB4018741 May 15, 2017
• 4017154 Intra-query deadlock on communication buffer when you run a bulk load against a clustered columnstore index in SQL Server 2016 Q4017154 KB4017154 May 15, 2017
• 4017013 FIX: Large memory allocations of type MEMOBJ_XSTMT occur when you run the sys.dm_exec_query_stats script in SQL Server Q4017013 KB4017013 May 15, 2017
• 4016613 FIX: Reporting Services web portal stops responding when you edit a subscription if a parameter has many available values in SQL Server Q4016613 KB4016613 May 15, 2017
• 4013609 FIX : Cannot sort subscriptions by column in SSRS 2016 web portal Q4013609 KB4013609 May 15, 2017
• 3197976 FIX: Transactions are not recorded after you deactivate leaf members in a staging table in Master Data Services Q3197976 KB3197976 May 15, 2017
• 3171132 Load or query attempt triggers "filegroup is full" error in SQL Server APS Q3171132 KB3171132 May 12, 2017
• 4013110 FIX: SSRS 2016 mobile report that contains a shared dataset times out and does not load Q4013110 KB4013110 March 20, 2017
• 4014354 How to use SQL Server 2016 in FIPS 140-2-compliant mode Q4014354 KB4014354 March 16, 2017
• 3198775 FIX: Inefficient query plan is used for a query requiring order by partitioning column of a table with single partition Q3198775 KB3198775 March 10, 2017
• 4013127 FIX: R Client 3.3.2 does not connect to Microsoft R Server on a Hadoop cluster by using PuTTY Q4013127 KB4013127 February 22, 2017
• 3206912 FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks Q3206912 KB3206912 February 21, 2017
• 3212252 FIX: Parameter values aren't contained in the URL when the parameter is used multiple times in a drillthrough custom URL Q3212252 KB3212252 January 18, 2017
• 3211220 FIX: KPIs bound to a dataset together with parameters are not updated during cache refresh Q3211220 KB3211220 January 18, 2017
• 3213778 FIX: MDS business rule does not trigger on an attribute value change if the attribute belongs to a change tracking group Q3213778 KB3213778 January 17, 2017
• 3213496 FIX: Cannot save a subscription when you browse to SSRS 2016 web portal by using Internet Explorer Q3213496 KB3213496 January 17, 2017
• 3210652 FIX: Automatic update of statistics feature doesn't run after you truncate a table that has a clustered columnstore index Q3210652 KB3210652 January 17, 2017