SQL Server 2014 SP2 Released

It was a dark and stormy night. The next morning, SQL Server 2014 SP2 arrived, chock full of fixes like:

• New DBCC CLONEDATABASE command to generate a statistics-only copy of the database for CE troubleshooting
• Faster performance for large databases with a large number of partitions
• More AlwaysOn (note the lack of space and AG in the headline) extended events and Perfmon counters
• Memory grant warnings in XML query plans
• Plans include trace flags
• Per-operator query execution statistics in query plans
• New min_grant_percent and max_grant_percent query hints
• Faster spatial queries
• Memory grant fields in sys.dm_exec_query_stats

And much more! Lots of good stuff for performance tuners in here. Go get ’em, tiger.