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

Updated to include SP1 CU11: There have already been eleven 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 […]

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) […]

Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

As we get ever closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July 8, 2014, I am very curious whether Microsoft is planning on releasing a SQL Server 2008 R2 Service Pack 3 or a SQL Server 2008 Service Pack 4 ? SQL Server 2008 […]

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 […]

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 […]

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 […]

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 […]