SQL Server 2014 Service Pack 1 release information

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

SQL Server 2014 Service Pack 1 release information

Highlights are:

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

FIX: Access violation occurs on the I/O Completion routine when you enable AutoClose in SQL Server 2014

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

FIX: Rollback causes database to go to suspect mode in SQL Server 2012 or SQL Server 2014

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

FIX: Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012 or 2014

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

SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2 and SQL Server 2014 Service Pack 1- displays machine information and product version information on startup

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

New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2 and SQL Server 2014 SP1

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

FIX: “Database ‘model’ cannot be opened” error when you restart SQL Server after tail-log backup for model database

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

FIX: Can’t connect to the server when you run a cube creation MDX query in SSAS 2012 or SSAS 2014

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

FIX: SQL Server crashes when the log file of tempdb database is full in SQL Server 2012 or SQL Server 2014

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

FIX: Rollback recovery on a snapshot fails when you run DBCC CHECKDB and then SQL Server shuts down unexpectedly

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

FIX: Incorrect data returned when you query the DATE column in SQL Server 2014

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

FIX: Non-yielding error occurs when you execute DML statements in SQL Server 2014

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

Error 17066 or 17310 during SQL Server startup

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

FIX: Non-yielding scheduler issue when you write pages to buffer pool extension file in SQL Server 2014

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

FIX: OS error 665 when you execute DBCC CHECKDB command for database that contains columnstore index in SQL Server 2014

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

FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function

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

FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014

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

FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING

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

FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014

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

FIX: Issues when you enable the buffer pool extension feature in SQL Server 2014

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

FIX: Query performance issues when new cardinality estimator is enabled in SQL Server 2014

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

FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014

Also the following VSTS bug numbers are fixed:

1957464 RESTORE HEADERONLY for an Encrypted Backup file of the Database does not show whether the backup is encrypted or not. After you apply SP1, the output of RESTORE HEADONLY will include three additional columns: KeyAlgorithm, EncryptorThumbprint and EncryptorType that can give additional details about the encrypted backup.

2580641 Invalid query syntax in stored procedure when you drop an article that is published in
more than one publication.

2580651Peer-to-peer (P2P) conflict messages include Table Name, Primary Key (s), Current Version, Pre Version and Post Version.

2580686    Update-Update conflicts in P2P replication when updates are made to text column by using UPDATE or WRITE.

2580693    Incorrect results when you work with block mode unary operators.

2580746    DPM’s full backup on the server with AlwaysOn secondary will be converted to copy_only backup

2581191    Merge Replication logging improvement:

2581192    Transaction Replication logging improvement:

2581382    Provides platform information in the log of SSRS 2014

3143194    LOB reads are shown as zero when “SET STATISTICS IO” is on during executing a query with clustered columnstore index.

3731350    When you use features that rely on log pool cache (for example, Always On) on systems with multiple sockets, you may notice high values for “log write waits” counter. Traceflag T9024 is not longer needed to activate the fix.

3732057    When your instance of SQL Server is handling thousands of connection resets because of connection pooling, performance problems occur when database lock activity increases in SQL Server. Traceflag T1236 is not longer need to activate the fix

3909490    Error 4819 occurs for some combination of database schema and data when the fast load context (TF610) for bulk load and TF4199 are enabled.

There are also some community connect items fixed, many ssms related.

https://connect.microsoft.com/SQLServer/feedback/details/735543/ssms-2012-express-create-a-new-db-from-another-dbs-backup-on-the-same-instance-actually-destroyed-the-original-db

https://connect.microsoft.com/SQLServer/feedback/details/745566/smo-2012-disregards-default-constraint

https://connect.microsoft.com/SQLServer/feedback/details/791929/system-assertion-failed-error-with-insert-into-partitioned-view-with-trigger

https://connect.microsoft.com/SQLServer/feedback/details/785151/show-actual-query-plan-causes-error

https://connect.microsoft.com/SQLServer/feedback/details/773710/unable-to-perform-full-text-ddl-after-reverting-from-db-snapshot

https://connect.microsoft.com/SQLServer/feedback/details/805659/sql-statement-is-nested-too-deeply

Advertisement

---