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 2016 SP1 CU8, 2014 SP2 CU11

4 years ago
Brent Ozar
SQL Server 2016, Updates
2 Comments

SQL Server 2016 SP1 CU8 has a whole bunch of Analysis Services fixes, plus:

  • Long restore times for encrypted databases
  • Memory leak in sys.dm_exec_cached_plans
  • Deadlocks when inserting into a partitioned clustered columnstore index
  • Dynamic data masking returns invalid data
  • Tempdb contention due to caching problems
  • UPDATE fails silently if you reference a non-existent partition function (hey, look, that’s your own dang fault)
  • Bad query plans when searching outside stats – I mention this only because it’s worth noting that this CU, like all CUs, can cause query plan changes. In a perfect world, you balance your urgency (or lack thereof) against your interest in getting a particular set of query plans fixed, and your ability to test those queries and document the differences that a CU provides.

The new SQL Server 2014 SP2 CU11 only has a handful of fixes, but they include:

  • Deadlocks not detected when you use a MERGE statement on a CCI (seriously, who uses MERGE? It’s a hot mess.)
  • AG failover occurs after a latch timeout
  • Long restore times for encrypted databases

If you’re planning your patch windows, keep in mind Microsoft’s Modern Servicing Model for 2017. In it, they wrote that CUs will be released “every month for the first 12 months.” Let’s see if they can keep up that frantic pace – the last CU for 2017 came out a month ago, so it should be out any day.

I wouldn’t expect to see any SQL Server 2012 updates anymore – 2012 hit SP4, and aside from urgent security updates, that’s about the end of that.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing SQL 2017 CU3, 2016 SP1 CU7 with Meltdown/Spectre Attack Mitigations
Next Post
Announcing SQL Server Management Studio SSMS 17.6

2 Comments. Leave new

  • Ron S
    March 20, 2018 3:34 pm

    Wow no wonder I have had some ‘challenges’ with Merge. Thanks for the info.

    Reply
  • Paul Roesler
    March 20, 2018 5:48 pm

    Looks like for us 2012 SP4’ers, we got till 2022/07/12 before they quit us…#sqlservertoughlove

    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

  • 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
  • Announcing SQL Server 2017 Cumulative Update 25: The Silver Anniversary July 12, 2021
  • Announcing SQL Server 2019 Cumulative Update 11: This One Goes to … June 11, 2021

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