SQL Server 2014 SP2 is just released recently. You can download it from here. It includes all the fixes from CU1 to CU7. There are a couple interesting things added in SP2:
- DBCC CLONEDATABASE (Transact-SQL) is introduced in SQL Server 2014 Service Pack 2: this is very useful for creating a quick clone of the database with statistics copied from the original database, but without the data. Then we can detach and move it to development server for doing the query tuning and performance trouble shooting.
- Adds a stored procedure for the manual cleanup of the change tracking side table in SQL Server 2014 SP2: Cheer for releasing the storage headaches.
- New query memory grant options are available (min_grant_percent and max_grant_percent) in SQL Server 2012: finally we got this in SQL Server 2014.