Today Microsoft have released Service Pack 2 for SQL Server 2014. In addition o some new fixes, SQL Server 2014 SP2 includes hotfixes that were included in SQL Server 2014 SP1 CU1 to SQL Server 2014 SP1 CU7. So this is a new branch of releases, and we will see cumulative updates separately for each of the branches of SQL Server 2014 (RTM, SP1 and SP2).
In addition to the CU fixes, There are 2 noticeable improvements to the release:
- Showplan XML will now include any trace flags in effect, actual rows read, per-operator performance metrics, and more details on spills.
- Index usage stats no longer get cleared after a rebuild
DBCC CLONEDATABASE()– create a stats-only copy of a database with minimal effort.
I particularly like this last one as it’s a pain creating stats only copies of databases for testing purposes.Follow @rPh0enix