Table of contents
×

This article contains important information to read before you install Microsoft SQL Server 2014 Service Pack 3 (SP3). It describes how to get the service pack, the list of fixes that are included in the service pack, known issues, and a list of copyright attributions for the product.

Note This article serves as a single source of information to locate all documentation that's related to this service pack. It includes all the information that you previously found in the release notes and Readme.txt files.

More Information

How to get SQL Server 2014 SP3

SQL Server 2014 SP3 and Microsoft SQL Server 2014 SP3 Express are available for manual download and installation at the following Microsoft Download Center websites.

SQL Server 2014 SP3

Download Download the package now.

SQL Server 2014 SP3 Express

Download Download the package now.


Note After you install the service pack, the SQL Server service version should be 12.0.6024.0. Microsoft SQL Server 2014 service packs are cumulative updates. SQL Server 2014 SP3 upgrades all editions and service levels of SQL Server 2014 through SQL Server 2014 SP3.

For more information about the cumulative updates that are available in SQL Server 2014, see SQL Server 2014 build versions .

List of improvements and fixes included in SQL Server 2014 SP3

Microsoft SQL Server 2014 service packs are cumulative updates. SQL Server 2014 SP3 upgrades all editions and service levels of SQL Server 2014 to SQL Server 2014 SP3. In addition to the fixes that are listed in this article, SQL Server 2014 SP3 includes hotfixes that were included in SQL Server 2014 Cumulative Update 1 (CU1) through SQL Server 2014 SP2 CU13.

Notes

  • Additional fixes that aren't documented here may also be included in the service pack.

  • This list will be updated when more articles are released.

For more information about the bugs that are fixed and enhancements that are included in SQL Server 2014 SP3, see the following Microsoft Knowledge Base articles.

VSTS bug number

KB article number

Description

11275485

3136242

FIX: New TCP connection is established and remains open until the process is terminated in SSIS 2014

10645271

4046870

Improvement: Replace HTTP URLs with HTTPS URLs in SQL Server 2014 Installation Wizard to improve security

12144118

4338890

FIX: "Non-yielding Scheduler" error and SQL Server appears unresponsive in SQL Server 2014, 2016 and 2017

6589008

3107173

Improved memory grant diagnostics using Extended Events in SQL Server 2012 and 2014

10065120

3136496

FIX: Access violation occurs when a query references an SQLCLR function through a synonym in SQL Server 2014 and 2016

10766202

3170019

Update to add info about SQL Server startup account to security policy in SQL Server 2012 and 2014 error log

10766201

3170020

Informational messages added for tempdb configuration in the SQL Server error log in SQL Server 2012 and 2014

10766203

3170115

Information about enabled trace flags is added to the showplan XML in SQL Server

10766207

3170116

FIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server

11441121

3173157

Adds a stored procedure for the manual cleanup of the change tracking side table in SQL Server

10766200

3191296

Update extends the Trace extended event with security protocol handshake information in SQL Server

10766205

3201552

Update adds overall query execution statistics information to the STATISTICS XML output in SQL Server 2012, 2014 and 2016

10766190

4013128

FIX: Decreased performance and long waits for CLR_AUTO_EVENT and CMEMTHREAD when SQLCLR UDT is used as a stored procedure parameter for a SQL RPC call

10766206

4016867

FIX: Data types of Query_hash and Query_hash_plan columns in xEvents do not match the data types in DMVs sys.dm_exec_requests and sys.dm_exec_query_stats

10766208

4016949

Unified Showplan Schema for different versions of SQL Server

9956168

4018930

Update adds the "CLR strict security" feature to SQL Server

11504303

4038113

FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server

10766227

4038210

FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed

8862297

4038418

Update adds a new column to DMV sys.dm_sql_referenced_entities in SQL Server 2014 and 2016

11061754

4038419

Update adds CPU timeout setting to Resource Governor workgroup REQUEST_MAX_CPU_TIME_SEC in SQL Server 2014, 2016 and 2017

11061701

4041809

Update adds support for MAXDOP option for CREATE STATISTICS and UPDATE STATISTICS statements in SQL Server 2014, 2016 and 2017

11061712

4041811

FIX: Automatic update of incremental statistics is delayed in SQL Server 2014, 2016 and 2017

11990860

4042415

FIX: Deadlock occurs on single-user mode database when many connections access it simultaneously in SQL Server 2014 and 2016

11542219

4042788

FIX: The tempdb system database is still encrypted after you turn off encryption on an instance of SQL Server

11715407

4051360

FIX: Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2

11715377

4051361

Optimizer row goal information in query execution plan added in SQL Server 2014, 2016 and 2017

11441136

4052129

Optimizer row goal information in query execution plan added in SQL Server 2014, 2016 and 2017

10766239

4056008

FIX: "sp_special_columns" returns incorrect result in SQL Server 2014 and 2016

11821775

4088193

FIX: Slow restore performance when restoring a compressed backup on a disk with 4K sector size in SQL Server

11814300

4099472

PFS page round robin algorithm improvement in SQL Server 2014, 2016 and 2017

11971859

4316858

FIX: "Corrupted index" message and server disconnection when an update statistics query uses hash aggregate on SQL Server

10895916

4092075

Improvement: Adds Service Broker support for DBCC CLONEDATABASE in SQL Server

12519464

4475794

FIX: Access violation exception occurs during Query Optimization of a query that accesses a table with Filtered Indexes or Statistics

References

For more information about how to determine the current SQL Server version and edition, select the following article number to go to the article in the Microsoft Knowledge Base:

321185How to identify your SQL Server version and edition

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×