SQL Server 2008 R2 Service Pack 1 (CTP) Available

Leave a comment (0) Go to comments

SQL Server 2008 R2 Service Pack 1 CTP(Customer Technology Preview) is available now for testing. Service Pack 1 for SQL Server 2008 R2 includes product improvements based on requests from the SQL Server community, and hot fixes solutions provided in SQL Server 2008 R2 RTM Cumulative Update 1 to 6.

Some of the major Key improvements in Microsoft SQL Server 2008 R2 Service Pack 1 are:

  • Version Upgrade, after installing this SP1 CTP, your sql server version will 10.50.2418.0

  • 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. New DMVs and XEvents on select performance counters are introduced to monitor OS configurations and resource conditions related to the SQL Server instance.

  • 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. Using old style syntax for FORCESEEK remains unmodified and works as before. In addition to that, a new query hint, FORCESCAN has been added. It complements the FORCESEEK hint allowing specifying ‘scan’ as the access method to the index. No changes to applications are necessary if you do not plan to use this new functionality.

  • Data-tier Application Component Framework (DAC Fx) For Improved Database Upgrade
    The new Data-tier Application (DAC) Framework v1.1 and DAC upgrade wizard enable the new in-place upgrade service for database schema management.  The new in-place upgrade service will upgrade the schema for an existing database in SQL Azure and the versions of SQL Server supported by DAC.  A DAC is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.

  • Disk SpaceControl For PowerPivot
    This update introduces two new configuration settings that let you determine how long cached data stays in the system. In the new Disk Cache section on the Power Pivot configuration page, you can specify how long an inactive database remains in memory before it is unloaded. You can also limit how long a cached file is kept on disk before it is deleted.

To download the SQL Server 2008 R2 SP1 release please select from the links below:

This SP1 for upgrade is applicable to following SQL Server 2008 R2 editions:

    (1) SQL Server 2008 R2 Parallel Computing Edition
    (2) SQL Server 2008 R2 Datacenter Edition
    (3) SQL Server 2008 R2 Enterprise Edition and Developer Edition
    (4) SQL Server 2008 R2 Standard Edition
    (5) SQL Server 2008 R2 Web Edition
    (6) SQL Server 2008 R2 Workgroup Edition
    (7) SQL Server 2008 R2 Express Edition
EOF - SQL Server 2008 R2 Service Pack 1 (CTP) Available, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.