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 Cumulative Update 1

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

Last night, Microsoft unveiled 13.0.2149.0, and it’s a big one. It includes pages and pages of fixes like:

  • Query Store automatic data cleanup was failing on Standard, Express, Eval Editions
  • Fatal error when you query sys.sysindexes if you have memory-optimized tables
  • Memory leak when DATA_CONSISTENCY_CHECK is run on a temporal table
  • Memory leak on AG replicas when change tracking is enabled
  • Temporal table data flush tasks consume 100% CPU
  • Temporal table query plans with a view on an identity field do infinite recompiles
  • SEEDING_MODE setting ignored when you add an AG replica
  • Cannot create/delete a table or index when another DDL transaction is running
  • Can run multiple UPDATE STATISTICS against a single table
  • READ_ONLY and AUTOGROW_ALL_FILES not preserved after a database restart
  • Fixed error 3456 that suspended AG replicas
  • Incorrect results when you use LIKE with an “ss” wildcard
  • Incorrect results with full text search
  • Crash when running a query with HASHBYTES
  • Non-yielding scheduler on queries with a UNION
  • Data loss when you alter a column on a large memory-optimized table
  • Data loss when you alter an in-memory temporal table
  • Data loss or incorrect results when you use sp_settriggerorder
  • Tons of Master Data Services fixes
  • FileTables unavailable after a failover in an AG
  • Availability databases not fully started after restarting an istance
  • Error 1478 when you add a database back into an AG
  • Online index operations were blocking on clustered columnstore indexes
  • All data was going to deltastores when you bulk loaded a clustered columnstore index under memory pressure
  • CHECKDB false errors on non-clustered columnstore
  • .NET Framework 3.5 required for log shipping secondaries
  • Cannot install non-English version on Windows Server Core
  • Canceling a backup task crashes SQL Server

Check out the full list of fixes and download the Cumulative Update.

Wanna know when new updates come out? Subscribe on our home page.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
SQL Server 2012 SP3 CU4, SP2 13 Released
Next Post
Announcing SQL Server 2012 SP3 CU5

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