SP2 CU8 includes the following:
- Restores of compressed encrypted backups fail
- Data masking doesn’t
- DAX query needs memory 200x larger than the database size
- Peer-to-peer replication fails if your host name isn’t uppercase
- Query Store cleanup can fill the transaction log and cause an outage
- Distributed Availability Groups cause memory dumps when automatic seeding
- AG replication stops working due to internal thread deadlocks
- The deadlock monitor can cause an access violation
- Query a view with a union on a linked server, boom
- Concurrent inserts into a clustered columnstore index can deadlock
- Infinite loop when FileTable is used for a long time without a restart
- SSAS 2016 randomly crashes (I’m gonna guess it wasn’t completely random if they fixed it)
- Transparent Data Encryption doesn’t encrypt if it’s restarted mid-encryption
The post SQL Server 2016 SP2 Cumulative Update 8 appeared first on SQLServerUpdates.com.