Facilitating the spread of knowledge and innovation in professional software development



Choose your language

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

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


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'.

We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


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.

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

Community comments

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

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


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.