May 14th, Microsoft has released the first Service Pack (SP1) for SQL Server 2014. It is more than thirteen months after the RTM version.
SQL Server 2014 Service Pack 1 includes all of the CU from 1 to 5.
Which issues are fixed in this SP1
There are 29 hotfixes:
- 19 for the Engine
- 6 for SSRS
- 3 for SSAS
- 1 for SSIS
Some improvements are:
- Performance improvement of Column store with batch mode operators and a new Extended Event
- Buffer pool extension improvement
- New cardinality estimator to boost queries performances
Historic of SQL Server 2014
The build version of SQL Server 2014 SP1 is 12.0.4100.1.
Here, a quick overview of SQL Server 2014 builds since the CTP1:
|Date||SQL Server 2014 version||Build|
|Juin 2013||Community Technology Preview 1 (CTP1)||11.00.9120|
|October 2013||Community Technology Preview 2 (CTP2)||12.00.1524|
|April 2014||Cumulative Update 1 (CU1)||12.00.2342|
|June 2014||Cumulative Update 2 (CU2)||12.00.2370|
|August 2014||Cumulative Update 3 (CU3)||11.00.2402|
|October 2014||Cumulative Update 4 (CU4)||12.00.2430|
|December 2014||Cumulative Update 5 (CU5)||11.00.2456|
|May 2015||Service Pack 1 (SP1)||12.00.4100|
If you need more information about SQL Server 2014 SP1 or to download it, click here.
As a reminder, Service Packs are very critical and important for bug fixing point of view, product upgrade so take care to install it quickly 😉