Service Pack 1 for SQL Server 2008 R2 is available now. Microsoft just rolled up all previous cumulative updates (1 to 6) as first upgrade for SQL Server 2008 R2.

Cumulative Update 7 and 8 are not included in SQL Server 2008 R2 SP1 but will be available for customers in SQL Server 2008 R2 SP1 Cumulative Update 1 shortly. Customers on SQL Server 2008 R2 Cumulative Update 7 or 8 will be able to upgrade to SP1 however will also need to apply SQL Server 2008 R2 SP1 Cumulative Update 1.
What’s New in SQL Server 2008 R2 Service Pack 1

  • Dynamic Management Views for increased supportability: sys.dm_exec_query_stats DMV is extended with additional columns to improve supportabilities over troubleshooting long-running queries.
  • ForceSeek for improved querying performance: Syntax for FORCESEEK index hint has been modified to take optional parameters allowing it to control the access method on the index even further.
  • Data-tier Application Component Framework (DAC Fx) for improved database upgrades: The new Data-tier Application (DAC) Framework v1.1 and DAC upgrade wizard enable the new in-place upgrade service for database schema management.
  • Disk space control for PowerPivot: This update introduces two new configuration settings that let you determine how long cached data stays in the system.

In addition, this update fixes many knowledge base issues that are listed in this Microsoft KB article.
Download: Service Pack 1 for Microsoft SQL Server 2008 R2

Leave a Reply

Your email address will not be published.