Microsoft SQL Server 2014 Service Pack 3 (SP3) has been recently released & details can be found in links below

Microsoft onWednesday announcedthe release of SQL Server 2014 Service Pack 3 (SP3).   SP3 brings new capabilities to Microsoft’s relational database management system. It adds “performance, scalability and diagnostics” improvements, according to Microsoft’s announcement. The new service pack is arriving about two years after the release of SP2, per Microsoft’s lifecycle page.

SP3 is a “cumulative update,” which means that it’ll upgrade “all editions and service levels of SQL Server 2014 to SQL Server 2014 SP3,” Microsoft’s support article explained. SP3 contains all past SQL Server 2014 hotfixes, as well.

Microsoft’s announcement described a number of improvements brought by SP3. It’s a long list, but here’s the short version:

  • An improved distribution database cleanup procedure.
  • Improved performance for “change tracking cleanup.”
  • Improved query handling based on CPU thresholds.
  • T-SQL syntax support for loading tables other than the “default filegroup.”
  • Backup performance improvements for small to medium databases on large-memory machines.
  • Database restore improvements for compressed “4K-sector volumes.”