Home > News, Uncategorized > Microsoft® SQL Server® 2008 R2 Service Pack 1

Microsoft® SQL Server® 2008 R2 Service Pack 1

Hi everyone!

Eventually SQL Server 2008 R2 Service Pack 1(SP1) has been released and now it is accessible for downloading. SQL Server 2008 R2 service pack updates all services of SQL Server 2008 R2 until SP1. Service pack includes all cumulative updates starting from 1 up to 6. You can use it easily to update the further list of SQL Server editions:

(1) SQL Server 2008 R2 Datacenter Edition
(2) SQL Server 2008 R2 Enterprise Edition and Developer Edition
(3) SQL Server 2008 R2 Standard Edition
(4) SQL Server 2008 R2 Web Edition
(5) SQL Server 2008 R2 Workgroup Edition
(6) SQL Server 2008 R2 Express Edition

Important: in order to update SQL Server 2008 R2 Express Edition, you should use SP1 for Express Edition or Express Edition with Advanced Services.

What new features  SQL Server 2008 R2 Service Pack 1 has?

  • Dynamic Management Views with enhanced support:

sys.dm_exec_query_stats DVM has been extended by additional columns for trouble shooting of long-running queries. DMV and XEvents for new performance counters allow tracking OS and resources configurations represented by SQL Server.

  • ForceSeek for query performance enhancement:

FORCESEEK syntax has been changed in order to control additional index access parameters. However, you can use the old version of FORCESEEK without any changes in your code. Additionally, the new parameter FORCESCAN has been added. Using this parameter you can simply force “scan” as a preferable access method to use any particular index. You should not do any changes in your code at all if you do not want to utilize new features.

  • Data-Tier Application Component Framework (DAC Fx):

New Data-Tier Application (DAC) Framework v 1.1 and DAC manager allow to use new service for DB updates. New update service can modify existed DB schemas in SQL Azure and SQL Server which support DAC. If you want to know more – you can follow this link Designing and Implementing Data-tier Applications.

  • Disk space control by PowerPivot

This feature adds two more new configuration settings which give you an ability to restrict the time how long data will be cached in a system. In a new section of configuration page PowerPivot called Disk Cache you can restrict how long an inactive DB will be in memory before it will be unloaded out for memory. Additionally you may define how long cache files will be stored on disks before they are dropped.

  • Bug fixing:

You can know more from here: http://go.microsoft.com/?linkid=9767514.

You can download new updates from here: http://www.microsoft.com/download/en/details.aspx?id=26727

Here you can ask questions: http://social.msdn.microsoft.com/Forums/ru-ru/fordataru/threads

Study more about SQL Server – http://technet.microsoft.com/ru-ru/sqlserver/


Source: Daniil Khabarov (http://blogs.msdn.com)

Reference: Aleksey Fomchenko (https://sqlconsulting.wordpress.com)


  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

%d bloggers like this: