SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

SQL Server 2014 SP2 Released

7 years ago
Brent Ozar
SQL Server 2014, Updates
1 Comment

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.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
New SQL Server 2014 Service Pack 1 Cumulative Update 7, plus CU14
Next Post
SQL Server 2012 SP3 CU4, SP2 13 Released

1 Comment. Leave new

  • kalimba
    July 12, 2016 8:36 am

    Also added support for new “Number of Rows Read” property

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021
  • Announcing 2016 Service Pack 3 and 2017 CU26 September 15, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy