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 SQL Server 2014 Service Pack 1 Cumulative Update 7, plus CU14

7 years ago
Brent Ozar
SQL Server 2014, Updates
No Comments

Microsoft just unveiled the latest fashions for their summer lineup. All the best-dressed SQL Server 2014s will be running the new Cumulative Update 7, which includes hotfixes for stuff like:

  • High CPU usage and PAGELATCH_* waits on SP1
  • Non-yielding scheduler errors on queries with a large number of OR clauses
  • Log shipping retries can write over a successful backup, breaking the log chain
  • Creating tables takes 10 minutes if you have 2-4TB memory
  • Service Broker leaks memory if you use TABLOCK hints in an AG
  • DBCC CHECKTABLE returns an incorrect result on rebuilt clustered columnstore indexes
  • Better query plans for columnstore indexes
  • Access violation when you combine TDE and BPE
  • MERGE fails when CDC is enabled (seriously, stop using MERGE)
  • Incorrect results when you use LIKE with “ss” against German data
  • Incorrect page numbers in SSRS exports
  • Change tracking cleanup fails if another database is offline
  • SQL doesn’t start if you set TempDB’s log file to be smaller than 248KB (look, that one is your own dang fault)

Read the SP1 CU7 details, or if you’re dead set against installing SP1 for some surely oddball reason, like you still like pleated pants, check out RTM CU14.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
SQL Server 2014 SP1 CU6 Fixed, Re-Released
Next Post
SQL Server 2014 SP2 Released

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 CU3: How Stella Got Her Groove Back April 13, 2023
  • 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

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