Infrastructure at your Service

Stéphane Savorgnano

SQL Server 2014: First Service pack (SP1) is available

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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Stéphane Savorgnano
Stéphane Savorgnano

Senior Consultant