SQL Server 2016 Cumulative Update 1

Guy-Glantser, 2016-08-04

On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to celebrate. Usually we are not as excited about cumulative updates as we are about service packs, but Microsoft has recently changed its incremental servicing model (ISM) for SQL Server, and according to new model, cumulative updates are tested and treated just the same as service packs.

So let’s raise a toast to the first SQL Server 2016 update…


The build number of this cumulative update is 13.0.2149.0, and it includes a lot of fixes and improvements (152 to be accurate), as described in details here. It’s interesting to see how the 152 fixes are distributed between the various fix areas, so I prepare the following chart for you:

Picture 2


As you can see, the majority of fixes (58) are in the SQL Server database engine (SQL Service), which is not surprising. After that, Reporting Services is leading with 25 fixes, which makes sense as there were a lot of changes and improvements to SSRS in SQL Server 2016.

Here is just an example of a fix included in this cumulative update. In SQL Server 2016 RTM, when you run a query that contains the HASHBYTES function, SQL Server will use all available memory and may crash. This was fixed in CU1. If you use the HASHBYTES function in queries in your application, then this is an important bug fix for you.


Remember that each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Microsoft recommends that you download and install the latest cumulative updates for SQL Server. Cumulative Update 1 can be downloaded from here.

The post SQL Server 2016 Cumulative Update 1 appeared first on Madeira Data Solutions.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads