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

Announcing SQL Server 2014 Service Pack 3

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

Flash back to July 11th, 2016. The world was pouring into theaters to see the remake of Ghostbusters:

But not you. You were hidden away in a data center, hard at work applying Service Pack 2 to your SQL Server 2014 instances.

Let’s be honest: you chose better than they did.

In the two years since, trusty ol’ Service Pack 2 has had 14 Cumulative Updates. Today, it’s time for him to retire and make way for Service Pack 3. Fixes include:

  • Less TempDB contention
  • Improved memory grant diagnostics using Extended Events
  • Trace flags show up in query plans
  • Wait stats, CPU time, elapsed time show up in query plans
  • Query_hash and query_plan_hash data types now match between XE and DMVs
  • Scalar UDF stats show up in query plans
  • Row goals show up in…oh, you get the point
  • Unified showplan schema for all supported versions
  • MAXDOP hint for creating and updating statistics
  • Faster restores on disks with 4K sectors

So get over here, and if you get a chance to re-watch the Ghostbusters remake, well…there is no remake. Only Zool.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing SQL Server 2017 CU12: OMG, THEY FINALLY FIXED “STRING OR BINARY DATA WOULD BE TRUNCATED”
Next Post
Announcing SQL 2017 CU13, 2014 SP3 CU1, SSMS 18.0 P6, OMG, BBQ

1 Comment. Leave new

  • Grzegorz Lyp
    October 31, 2018 6:14 am

    Pedro Lopez announced SP3 to be at the end SQL 2014 support date. That cuts the discussion.

    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