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

New Service Pack 4 for SQL Server 2012

5 years ago
Brent Ozar
SQL Server 2012, Updates
2 Comments

FORE!

Download Service Pack 4 here, and here’s the list of bugs it fixes.

Should you install it? Sometimes people think, “I don’t need to bother installing this update because I’m not having any problems.” Well, friend, check out KB #3146404: canceling a backup crashes SQL Server. You don’t wanna run into that, now, do you?

It also includes improvements for query tuners:

  • Trace flags are included in the query plan XML
  • CPU time and elapsed time are also included in the plan (so are some wait stats, but careful because the waits aren’t accurate)
  • Memory grants shown in the plan now include nested loop join operators

So start planning your outage windows now. Besides, it’s probably the last one we’re gonna have for 2012, right? We’ve never had a Service Pack 5 before. Although we’ve never had SQL Server on Linux before, either, so…maybe.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
New Cumulative Updates for SQL Server 2012, 2014, and 2016
Next Post
SQL Server 2016 SP1 Cumulative Update 6 Released

2 Comments. Leave new

  • Greg White
    October 6, 2017 2:35 pm

    https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-2012-service-pack-4/
    “The SQL Server team is excited to bring you the last service pack release for SQL Server 2012.”
    … sad face 🙁

    Reply
  • Plop
    October 6, 2017 5:25 pm

    The last SP and CU we’ll ever see for SQL 2012.

    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