SQL Server 2016 CU2 Available Now

SQL Server

Microsoft has announced that cumulative update package 2 (build number: 13.0.2164.0) for Microsoft SQL Server 2016 is now available. This update includes all fixes since the last service pack:

VSTS bug number KB article number Description Fix area
7990674 3178541 PivotTable connects to incorrect data source in SQL Server 2012 or 2014 PowerPivot for SharePoint Analysis Services
8198014 3174476 FIX: Deadlock occurs when you acquire a SCH-M lock and alter a partition in SQL Server 2014 or 2016 SQL service
8197977 3176440 FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 or 2016 SQL service
7990669 3171516 Update to add a security warning message when you schedule data refresh for PowerPivot workbooks Analysis Services
7955222 3183440 Error when you use SecurityFilteringBehavior enumeration in SQL Server 2016 Analysis Services Analysis Services
7855195 3157016 FIX: RDL report that’s generated programmatically fails to run in SSRS Reporting Services
8198000 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016 Integration Services
8001820 3189229 FIX: “Element not found” error occurs when you browse to the FileTable database directory in SQL Server 2012 or 2016 SQL service
8260699 3189372 Query returns incorrect results from nonclustered columnstore index under snapshot isolation level in SQL Server 2016 SQL service
7990705 3070382 FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name SQL service
8197968 3153836 Operating system error 32 when you restore a database in SQL Server 2014 or 2016 SQL service
8275126 3189264 Incorrect results are returned when you execute a query that contains a GROUP BY operation in SQL Server 2016 SQL performance
7990651 3156452 FIX: “‘Salt’ attribute for OraPassword is missing” error in SSIS in SQL Server 2012 or 2014 Integration Services
8275709 3189060 Standard edition of SQL Server 2016 Analysis Services (Tabular mode) ignores the 16 GB memory limit Analysis Services
7990694 3177666 FIX: Cannot create or manage data alert for a report if the report name or folder name contains a comma in SSRS Reporting Services
8208448 3187654 Update to add support for the Analyze in Excel feature for some regions in Power BI Analysis Services
8273336 3189364 Query Store returns unusual characters when a JOIN operator is used in SQL Server 2016 SQL service
8208393 3192154 A non-optimal query plan choice results in poor performance when values outside the range represented in statistics are searched in SQL Server 2016 SQL performance
7779870 3171505 FIX: “The service is not available” error when you use SSRS 2016 Portal after you disconnect from the domain Reporting Services
7855159 3168707 FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 or 2016 Management Tools
7990714 3166545 FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows SQL connectivity
8037273 3181526 Calculation using two measure time values in iterations returns negative values in SQL Server 2014 or 2016 SQL service
8208296 3187493 FIX: DISCOVER_TABLE_STORAGE_COLUMN_SEGMENTS DMV returns an incorrect result of memory usage in SQL Server 2016 Analysis Services
8255153 3188950 Updating while compression is in progress can lead to nonclustered columnstore index corruption in SQL Server 2016 SQL service
8198030 3176993 FIX: The “MSRS 2014 Windows Service: Active Session” counter incorrectly displays a very high value for SSRS 2014 or 2016 Reporting Services
7990660 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
7873772 3184135 Cannot open a Reporting Services report from the SSRS portal when the host computer has FIPS compliance enabled Reporting Services
7855214 3106976 FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 or 2016 SQL security
7837980 3174812 FIX: Queries on Stretch Database enabled databases always involves a network round-trip to Azure in SQL Server 2016 SQL service
7944505 3186433 FIX: Cannot print a Reporting Services report from the SSRS 2016 web portal Reporting Services
8198017 3181444 FIX: Queries that run against secondary databases always get recompiled in SQL Server High Availability
8075960 3189655 Error 33294 if a cursor is declared by using the OPTION (RECOMPILE) query hint in SQL Server 2016 SQL security
7990723 3170051 FIX: SQL Server failover cluster diagnostic log doesn’t accurately reflect the failure_condition_level setting High Availability
7855169 3160427 FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
8198041 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
7989907 3185650 FIX: Access violation occurs when execute a query that contains many COUNT DISTINCT operations in SQL Server 2016 SQL service
7855191 3168710 FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016 SQL service
8197974 3161403 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server Reporting Services
8208458 3192117 An access violation occurs when you execute a query if trace flag 4139 is enabled in SQL Server 2016 SQL performance
8045133 3183721 “The connection string is not valid” error occurs when you use a data source of type Microsoft SharePoint List in SQL Server 2016 Reporting Services Reporting Services
7855179 3162589 FIX: High CPU usage on SQL queries after you install SQL Server SQL service
8197987 3165168 Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server SQL service
8086115 3188978 FIX: “Cannot bulk load” error when you run a query that contains an UPDATE statement in SQL Server 2016 SQL performance
7855184 3168709 SQL Server 2014 or 2012 doesn’t start after you configure the tempdb database to use a very small log file SQL service
7779870 3171505 FIX: “The service is not available” error when you use SSRS 2016 Portal after you disconnect from the domain Reporting Services
7855174 3161119 FIX: Change tracking cleanup task fails if another database is offline in SQL Server 2014 or 2016 SQL service
8197990 3179596 “Failed Assertion = ‘m_pExclusiveOwner != pWorker'” is continuously logged in the SQL Server 2014 or 2016 error log SQL service
7990660 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
8268335 3189276 Adds the support to audit the information that’s collected by the SQL Server Usage Feedback Collection SQL service
7990720 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
8258545 3188368 FIX: Access violation on secondary replica when there are too many parallel redo operations in SQL Server 2016 High Availability
8258377 3191515 Cannot filter the mobile report correctly when the parameter contains special characters in SQL Server 2016 Reporting Services Reporting Services
8357071 3192687 The rxExec function does not run the rxDataStep function in parallel on Windows operating systems SQL service
8208291 3187549 FIX: Affinity mask does not work correctly for NUMA nodes in SQL Server 2016 Analysis Services Analysis Services
8204190 3192636 Data grid becomes blank when you scroll if the “Row numbers” option is set to Hide in a SQL Server 2016 Reporting Services mobile report Reporting Services
8198027 3178526 An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 or 2016 SQL connectivity
8058912 3182868 FIX: Queries that contain recursive CROSS APPLY operations run slowly in SQL Server 2016 SQL security
7762097 3189055 IntelliSense feature displays incomplete or incorrect information for the AMO library Analysis Services
8048420 3188980 FIX: Duplicate mobile reports and KPIs are displayed in Power BI Mobile app Reporting Services
8291010 3184227 “The remote server ‘(null)’ does not exist” error occurs after you remove an article from a publication in SQL Server SQL service
7855176 3154482 FIX: Service Broker UCS task leaks memory in SQL Server 2014 or 2016 SQL service
8197993 3167159 FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan SQL performance
8198024 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services

You can read more about this update here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s