List of new changes in SQL2014 SP1

Microsoft has release SQL Server 2014 Service Pack 1 on April 15 and recalled very shortly after going live on the Microsoft Download Center (only) to address a recall issue.  After resolving that issue the new release is now available –KB3058865.

Here are the couple of changes that you will experience after patching.

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

02. Error when you add a custom connection manager in SSIS 2014 Designer

03. Rollback causes database to go to suspect mode in SQL Server 2012 or SQL Server 2014

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

05. SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2

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

07. New log files are not created when you restart the Reporting Services Windows Service in SSRS on January 1

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

09. Event ID 22 or error 0xC1000016 will be logged when you use the Discover command in SSAS 2012

10. File Share subscription doesn’t populate the description column in SSRS 2012 or SSRS 2014

11. The “Name” drop-down list is empty when a report is specified in SSRS 2012 or SSRS 2014

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

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

14. Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 or 2014 report

15. Text truncated when you use HPB renderer to view a report in SSRS 2012 or in SSRS 2014

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

17. Incorrect data returned when you use DATE data type as a qualifier in a query in SQL Server 2014

18. Non-yielding error occurs when you execute DML statements in SQL Server 2014

19. Error 17066 or 17310 during SQL Server startup

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

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

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

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

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

25. AlwaysOn availability groups are reported as NOT SYNCHRONIZING

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

27. Issues when you enable the buffer pool extension feature in SQL Server 2014

28. Query performance issues when new cardinality estimator is enabled in SQL Server 2014

29. Consuming reports on a remote farm does not work in SharePoint Integrated for a published SSRS 2014 Service application

This entry was posted in Uncategorized and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s