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

b2ap3_thumbnail_PieSQL2014SP1.jpg

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 RTM 12.00.2000
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 😉
See you.


Thumbnail [60x60]
by
Stéphane Savorgnano