SQL Server 2014 RTM Cumulative Update 5

Microsoft has released SQL Server 2014 RTM Cumulative Update 5, which is Build 12.0.2456. This cumulative update has 47 fixes in the Public hotfix list. This handy Microsoft KB article “SQL Server 2014 build versions”, lists all of the cumulative updates that have been released for SQL Server 2014, including this one. If you have […]

SQL Server 2012 SP2 Cumulative Update 3

Microsoft has released SQL Server 2012 SP2 Cumulative Update 3, which is Build 11.0.5556. This CU has 34 hotfixes in the public fix list. If you are running SQL Server 2012, this is the build you should be planning to get installed, after you have done your testing and planning for the installation. They have […]

SQL Server 2014 RTM CU4

Microsoft has released SQL Server 2014 RTM CU4, which is Build 12.0.2430. This cumulative update has 54 hotfixes in the public fix list, which is a fairly large number. As usual, I think you should take a close look at the list of hotfixes, and then think pretty seriously about going through the testing and […]

SQL Server 2012 SP1 CU12 and SP2 CU2 Released

Microsoft has released SQL Server 2012 Service Pack 1 CU12 (Build 11.0.3470) and SQL Server 2012 Service Pack 2 CU2 (Build 11.0.5548). Both of these CUs (which were released on the same day) have a significant number of valuable hotfixes. SP1 CU12 has 14 hotfixes, and SP2 CU2 has 50 hotfixes. Needless to say, I […]

Small Enhancement to Microsoft SQL Server CU Knowledge Base Articles

Microsoft has made a small, but helpful improvement to the format for their Knowledge Base articles that accompany new Cumulative Updates for SQL Server 2012 and SQL Server 2014. As you hopefully know, there will not be any more cumulative updates for SQL Server 2008 or SQL Server 2008 R2, since those versions are now […]

SQL Server 2014 RTM Cumulative Update 3

Microsoft has released (about a week early by my calendar) SQL Server 2014 RTM Cumulative Update 3, which is build 12.0.2402. It has 32 fixes in the public fix list. As always, I think that you should strongly consider applying this update to your SQL Server 2014 instances, after you have done your normal round […]

Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds

Updated to include SP1 CU13: There have already been thirteen Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012 over the past two years. SQL Server 2012 […]

SQL Server 2014 RTM Cumulative Update 2

Microsoft has released SQL Server 2014 RTM Cumulative Update 2, which is Build 12.0.2370.0. It has 48 hotfixes in the public fix list. This is one of the more interesting fixes: FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server […]

Performance Related Fixes in Post-SQL Server 2008 Service Pack 3 Builds

As you may be aware, Microsoft released SQL Server 2008 Service Pack 3 back around October of 2011. Even though there has not been an official announcement yet from Microsoft, it seems likely that there will not be a SQL Server 2008 Service Pack 4 release before SQL Server 2008 (and SQL Server 2008 R2) […]

Most Recent Cumulative Updates for SQL Server 2008-2014

Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) SQL Server 2014 RTM CU2 (12.0.2370)           released on June 27, 2014 Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB […]

SQL Server 2012 Service Pack 1 CU9

On March 17, 2014, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 9. This is Build 11.0.3412, and it has 30 hotfixes in the public fix list. This CU is only for SQL Server 2012 Service Pack 1. If you are still on the SQL Server 2012 RTM branch, you do not want […]

Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds

Updated to include SP1 CU9: There have already been nine Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012 over the past eighteen months. SQL Server 2012 […]

Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 2 Builds

As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying current with both SQL Server Service Packs and SQL Server Cumulative Updates. This is also something that SQLskills recommends on our customer engagements. Despite this, it is still quite common […]

Most Recent Cumulative Updates for SQL Server

Here are the most recent cumulative updates for SQL Server 2012, 2008 R2 and 2008. SQL Server 2012 RTM CU10 (11.0.2420)          released on October 21, 2013 SQL Server 2012 SP1 CU6 (11.0.3381)            released on September 16, 2013 If you are on SQL Server 2012, both RTM and Service Pack 1 are still a “supported service […]

SQL Server 2008 R2 SP2 CU9

Microsoft has released SQL Server 2008 R2 SP2 CU9, which is Build 10.50.4295. This CU has eighteen hotfixes in the public fix list. Some of the more important ones are listed below: FIX: Poor performance when SQL Server 2008 or SQL Server 2008 R2 requires memory from a local node in a NUMA environment FIX: […]

SQL Server 2012 RTM Cumulative Update 10

Microsoft has released SQL Server 2012 RTM Cumulative Update 10 (Build 11.0.2420). This CU only has four fixes in the Public hotfix list. Two for SSAS, one for SSRS, and one for the Database Tuning Advisor (DTA). From a Database Engine perspective, there is not too much to get excited about for this particular cumulative […]

Performance Related Fixes in Post-SQL Server 2012 SP1 Builds

There have already been six Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these early Cumulative Updates, as more people are using SQL Server 2012 over time. SQL Server 2012 SP1 has all of the fixes through […]

SQL Server 2012 Service Pack 1 Cumulative Update 4

On May 31, Microsoft finally posted SQL Server 2012 Service Pack 1 Cumulative Update 4, which is Build 11.0.3368. This release was about two weeks later than expected, which is a little unusual for Cumulative Updates. I count 38 fixes in the public fix list. These are probably the two most interesting fixes for the […]

Performance and Stability-Related Fixes in All SQL Server 2008 SP2 Cumulative Updates

SQL Server 2008 Service Pack 2 was retired and became an “unsupported service pack” back on September 17, 2012. Despite this, I have been running into a lot of systems lately that are still running SQL Server 2008 Service Pack 2 or older lately, so I thought it made sense to follow up my previous […]

Performance and Stability-Related Fixes in All SQL Server 2008 SP3 Cumulative Updates

Even though there are two newer, major releases of SQL Server available, there are still many organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. SQL Server 2008 (and SQL Server 2008 R2) are scheduled to fall out of mainstream support on July […]

SQL Server 2008 Service Pack 3 Cumulative Update 11

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 11, which is Build 10.0.5840.00. There are six hotfixes in the public fix list. There is no corresponding cumulative update for earlier service pack levels for SQL Server 2008, since they are retired. If you are on SQL Server 2008, you really should be […]

How to Find Out About the Latest SQL Server Service Packs and Cumulative Updates

Since someone asked me about this today, I thought I would write about it.  Aaron Bertrand (blog|twitter) and I sort of have a friendly competition to be the first to blog when a new SQL Server CU is released.  I don’t know of any e-mail notification service for Service Packs and Cumulative Updates from Microsoft. […]

Clarification of Microsoft’s SQL Server 2012 Servicing and Support Policy

I recently recently got some very helpful clarification from a friend at Microsoft about Microsoft’s plans for how they will be servicing SQL Server 2012 over the rest of 2013, and how these plans will work with their mainstream support policy. I don’t think this is any great change, but it is a welcome explanation […]

Microsoft Update offering SQL Server 2012 SP1 Cumulative Update 2

I was doing some routine maintenance on one of the SQLskills lab servers (a pretty nice Dell PowerEdge R720) on Sunday night when I noticed that Microsoft Update (which is a superset of Windows Update) was offering “Update Rollup for SQL Server 2012 Service Pack 1 (KB2790947)” as an Optional Update for a Windows Server […]

SQL Server 2008 R2 Service Pack 1 Cumulative Update 11

On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 1 Cumulative Update 11, which is Build 10.50.2869. There are only four fixes in the public fix list for this cumulative update. This cumulative update is only for SQL Server 2008 R2 Service Pack 1. If you have a different version and/or service […]

SQL Server 2008 R2 Service Pack 2 Cumulative Update 5

On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 2 Cumulative Update 5, which is Build 10.50.4276. There are 21 fixes in the public fix list for this cumulative update, which is a pretty decent amount of fixes. This cumulative update is only for SQL Server 2008 R2 Service Pack 2. If […]

SQL Server 2012 RTM Cumulative Update 6

On February 18, 2013 Microsoft released SQL Server 2012 RTM Cumulative Update 6, which is Build 11.0.2401. This CU has 22 fixes listed in the public fix list, which is quite a bit fewer hotfixes than in the first five cumulative updates for the RTM branch of SQL Server 2012. I take this as a […]

SQL Server 2012 Service Pack 1 Cumulative Update 2

On January 21, 2013, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 2, which is Build 11.0.3339. This Cumulative Update has 50 hotfixes by my count, and two new features (which is quite unusual for a SQL Server Cumulative Update). This CU gets the SQL Server 2012 Service Pack 1 branch to parity […]

Important Hotfix for SQL Server 2008 and Newer

Microsoft recently released a hotfix for a memory leak leak issue that affects SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. This memory leak only occurs if the have the AUTO_UPDATE_STATISTICS_ASYNC database level setting enabled for any of your databases. Here is how Microsoft describes the issue in the hotfix KB article: […]

Performance and Stability-Related Fixes in Recent SQL Server 2008 SP3 Cumulative Updates

Even though I like to talk about the most recent major releases of SQL Server, there are still plenty of organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. Lets assume that you have been pretty diligent about keeping your SQL Server 2008 […]

Performance Related Fixes in Post-SQL Server 2012 RTM Builds

There have already been five Cumulative Updates (CU) for the RTM branch of SQL Server 2012. Microsoft has also released SQL Server 2012 Service Pack 1, along with SQL Server 2012 SP1 Cumulative Update 1, with Cumulative Update 2 being due in the near future. There have been a high number of hotfixes in every […]

Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 1 Builds

As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying current with both SQL Server Service Packs and SQL Server Cumulative Updates. This is also something that SQLskills recommends on our customer engagements. Despite this, it is still quite common […]

How to Obtain and Install SQL Server Service Packs and Cumulative Updates

If you are in charge of one or more SQL Server instances, whether they are on your laptop, or a large Production data center, you should be aware of how SQL Server updates and fixes are released, and how you can obtain them from Microsoft. First, a few definitions: RTM means Release to Manufacturing. It […]