Administration & Tools

SQL 2014 service pack for SP1 or CU7?

https://support.microsoft.com/en-us/kb/2936603

SQL service pack SP1 is announced.

https://support.microsoft.com/en-us/kb/2936603

And CU7 and SP1 both of the latest build for now.

The problem is, SP1 has higher version. But, it looks not containing CU6 and CU7.

CU6 and CU7 include very critical KB as well.

You may not want to apply SP1. Please check CU6 and CU7 first.

ServicePackVSTS bug numberKB article numberDescriptionFix area
CU640672653016165FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL ServerSQL service
CU640673003021757FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR functionSQL service
CU639864653024815Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014SQL performance
CU639154023025845FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014SQL service
CU640672603026082FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014SQL service
CU640672633026083FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014SQL service
CU638564393029762FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014SQL service
CU640673123029825FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014SQL performance
CU638853663030041FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014Setup & Install
CU637499613030619FIX: Incorrect data returned when you use DATE data type as a qualifier in a query in SQL Server 2014SQL service
CU640722353034615FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014SQL service
CU640457763034679FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZINGHigh Availability
CU742107823042544FIX: A query that requires nested loops join takes longer to complete in SQL Server 2014SQL performance
CU743265993044958FIX: Rollback recovery on a snapshot fails when you run DBCC CHECKDB and then SQL Server shuts down unexpectedlySQL service
CU743265973032476FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012 or 2014SQL service
CU743362643037624FIX: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014SQL performance
CU742656523042370An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014SQL service
CU743266003042135FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012 or SQL Server 2014SQL service
CU740569443048752FIX: A SELECT query run as a parallel batch-mode scan may cause a deadlock situation in SQL Server 2014SQL service
CU743027393052404FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014SQL connectivity
CU743296493048856FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014SQL service
CU640672803011465FIX: Sequence object generates duplicate sequence values when SQL Server 2012 or SQL Server 2014 is under memory pressureSQL service