BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

SQL Server 2008 R2 SP1 Brings Easier Schema Upgrades, Improved Query Performance

| by Roopesh Shenoy on Jul 22, 2011. Estimated reading time: 1 minute |

SQL Server 2008 R2 SP1 brings several features such as DAC Framework for easier schema upgrades, new DMVs and XEvents for better supportability, Improved Query Performance with ForceSeek and ForceScan and Disk space control for PowerPivot.

A brief explanation of the new features introduced -

  • Data-tier Application Component Framework (DAC Fx) DAC allows the database schema of an application to be packaged as a Data-tier Application; now using an upgrade wizard enables an in-place upgrade service, making it much easier to deploy schema changes.
  • sys.dm_query_stats Dynamic Management View is extended with additional columns to improve supportabilities over troubleshooting long-running queries. There are also some new DMVs for monitoring OS configurations and resource conditions
  • FORCESEEK now takes optional parameters to give greater flexibility. FORCESCAN hint has been added, which combines with FORCSEEK to force and index ‘scan’.
  • Disk space control in PowerPivot for SharePoint - two new configuration settings that let you determine how long cached data stays in the system. You can now specify how long an inactive database remains in memory before it is unloaded and limit how long a cached file is kept on disk before it is deleted.

There is also a list of bugs fixed in the Service Pack, which rolls up all the updates 1 through 6 for SQL Server 2008 R2.

SQL Server 2008 R2 Feature pack, which was also previewed alongside the SP1 in April, was also released recently, and is available for download. The Release announcement coincided with the CTP3 release of SQL Server 'Denali'.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT