SQL Server 2014 Service Pack 1 is now available

SQL Server team just announced the availability of SQL Server 2014 SP1 via the SQL Server blog. Before installing SP1, please read the following warning published on the blog.

Notice: There is an issue with SQL Server 2014 SP1 installation if SSIS catalog is present. The package download is temporarily unavailable while the issue is investigated. We will update this page when it is available again.

The Blog continues:

“Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments.”

The list of fixes in SP1 are:

  • Column store performance is improved when batch mode operators spill over to disk. A new XEvent provides insights into column store inserts.
  • Several issues in buffer pool extension SSD configuration are addressed, including the ability to do instant initialization of the buffer pool extension file.
  • Certain queries compile faster when using new cardinality estimator, and other cardinality estimation query plans are more efficient when using TF-4199.
  • The scalability benefits of two trace flags (TF-1236, TF-9024) are applied automatically.
  • Backup header information retrieval works better with encrypted backups.