It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack 3and its feature pack. SQL Server 2008 R2 SP3 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 R2 Service Pack 2 up to and including Cumulative Update 13.
I have personally switched to SQL Server 2014 few months ago and I am happy with its performance and robust behavior. Many of the customer and clients are still using SQL Server 2012. However, if you are using SQL Server 2008 R2, I suggest that you look at upgrading to the latest version of SQL Server or at least update your software with latest service pack.
You can download SQL Server 2008 R2 Service Pack from following link:
Microsoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all editions of SQL Server 2012. This service pack contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9). Here is the list of the bugs which are fixed in SQL Server 2012 SP2.
If you are facing any of the following issues and have not installed any of the cumulative updates, you should indeed update to SQL Server 2012 SP2. On my personal development server, I have upgraded this SP2 and after a week’s testing, I am planning to roll it out to my production server.
I am very excited about the bug fix of Poor Performance when using table variables, as I had just talked about during my last presentation in India.
Can’t connect to the server when you run a cube creation MDX query in SSAS 2012
Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 report
Text truncated when you use HPB renderer to view a report in SSRS 2012
SQL Server crashes when the log file of tempdb database is full in SQL Server 2012
SSRS 2012 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB
SSRS 2012 cannot export a report that is larger than 10 MB to Excel format
Rollback causes database to go to suspect mode in SQL Server 2012
Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012
New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2
New log files are not created when you restart the Reporting Services Windows Service in SSRS 2012 on January 1
No error message when log backup failed in SQL Server 2012
Visual Studio 2012 crashes because of access violation when the data source binding is completed in Report Viewer 2012 UI in local mode
File Share subscription doesn’t populate the description column in SSRS 2012
The “Name” drop-down list is empty when an SSRS 2012 report is specified
Event ID 22 or error 0xC1000016 will be logged when you use Discover command in SSAS 2012
Performance issues when you use SSISDB as your deployment store in SQL Server 2012
SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2
Poor performance when you use table variables in SQL Server 2012
Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012
Last week, I was attending SQLPASS 2012 and I had great fun attending the event. During the event long awaited SQL Serer 2012 Service Pack 1 was released. I am pretty excited with SP1 as new service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP1. This service pack contains SQL Server 2012 Cumulative Update 1 (CU1) and Cumulative Update 2 (CU2).
The latest SP1 has many new and enhanced features. Here are a few for example:
Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade
Selective XML Index
DBCC SHOW_STATISTICS works with SELECT permission
New function returns statistics properties – sys.dm_db_stats_properties
SSMS Complete in Express
SlipStream Full Installation
Business Intelligence highlights with Office and SharePoint Server 2013
Management Object Support Added for Resource Governor DDL
Please note that the size of the service pack is near 1 GB.
Service packs are very critical and important. In the industry I have seen many people waiting for the first service pack to arrive before moving to opting the product. I often see it as a good practice because there are some unknown bugs or missed enhancements in original product which are later covered in the SP2. I believe it is not limited to SQL Server but pretty much true across most of the softwares. Here is a single suggestion, you may delay adopting the product but must not delay in adopting service packs. As soon as they are released, grab them, test them on your development thoroughly and move to production server after validating.
Microsoft has recently released SQL Server 2008 R2 service packs. Please note these are for SQL Server 2008 R2 and not for SQL Server 2008. They will not work on SQL Server 2008 but will work only on SQL Server 2008 R2. If you have have a fresh install of SQL Server 2008 R2, you just have to download and install SP2 and there is no need to install SP1 as this service pack is cumulative SP and contains all the previous upgrades of SP1.