Microsoft have released Cumulative Update 1 for SQL Server 2016 SP2!
This Cumulative Update provides the following fixes (https://support.microsoft.com/en-us/help/4135048/cumulative-update-1-for-sql-server-2016-sp2):
- Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016
- FIX: Error when a SQL Server Agent job executes a PowerShell command to enumerate permissions of the database
- FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014, 2016, and 2017
- FIX: “Cannot use SAVE TRANSACTION within a distributed transaction” error when you execute a stored procedure in SQL Server
- FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services
- PFS page round robin algorithm improvement in SQL Server 2016
- FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS
- FIX: A memory assertion failure occurs and the server is unable to make any new connections in SQL Server
- FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server
- Improvement: Performance issue when upgrading MDS from SQL Server 2012 to 2016
- FIX: Error in the MDS Add-in for Excel when you use the German version of Excel in SQL Server
- FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server
- FIX: One worker thread seems to hang after another worker thread is aborted when you run a parallel query in SQL Server
- FIX: TDE enabled database backup with compression causes database corruption in SQL Server 2016
- FIX: Restore of a TDE compressed backup is unsuccessful when using the VDI client
- FIX: Performance is slow for an Always On AG when you process a read query in SQL Server
- FIX: An internal exception access violation occurs and the SSAS server stops responding
- FIX: Floating point overflow error occurs when you execute a nested natively compiled module that uses EXP functions in SQL Server
- FIX: Database cannot be dropped after its storage is disconnected and reconnected in SQL Server
- FIX: TDE enabled database backup and restore operations are slow when the encryption key is stored in an EKM provider in SQL Server
- FIX: Processing a cube with many partitions generates lots of concurrent data source connections in SSAS
- FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016
- FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error
- FIX: An assertion failure occurs when you execute a nested select query against a columnstore index in SQL Server
- FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode
- FIX: RESTORE HEADERONLY statement for a TDE compressed backup takes a long time to complete in SQL Server
- FIX: Hidden parameters are included in reports when the Browser role is used in SSRS 2016
- FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server
This cumulative update can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=56975