SQL Server 2008 R2 Sp1 veröffentlicht
Microsoft hat am heutigen Tag das Sp1 für den SQL Server 2008 R2 veröffentlicht.
What's New in Service Pack 1
The following features are new in Service Pack 1 (SP1).
**Dynamic Management Views **for increased supportability. sys.dm_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 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. 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 space control in PowerPivot for SharePoint. 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 PowerPivot 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.
Support for 512e Drives. SQL Server now correctly detects and supports hard drives with the new 512e format. These drives report 512 byte logical sector sizes, but they are formatted internally using 4KB sectors. When SQL Server 2008 R2 SP1 is installed on Windows Server 2008 R2 or higher, we will correctly detect these drives and adjust automatically.Fixed various issues. This update fixes many SQL Server 2008 R2 issues that are
> . It also includes some additional fixes that improve the product quality.
Download:
Microsoft® SQL Server® 2008 R2 Service Pack 1 - Deutsch
Microsoft® SQL Server® 2008 R2 Service Pack 1 - Englisch
Microsoft® SQL Server® 2008 R2 SP1 - Express Edition - Deutsch
Microsoft® SQL Server® 2008 R2 SP1 - Express Edition - Englisch
Wie man das Sp1 in eine R2 DVD integriert wird hier beschrieben:
How to slipstream SQL Server 2008 R2 and a SQL Server 2008 R2 Service Pack 1 (SP1)
Somit ist das Sp1 gleich bei der Installation vom SQL Server installiert und man spart sich die nachträgliche Installation.
Nun gibt es schon das erste Kumulative Update, dass die Kumulativen Updates 7,8 vom SQL Server 2008 R2 RTM beinhaltet, weil das Sp1 nur alle Updates bis zum Kumulativen Update 6 enthält.
Cumulative update package 1 for SQL Server 2008 R2 Service Pack 1
Geht auf "View and request hotfix downloads", tippt eure Email-Adresse 2 mal ein und bestätigt das Captcha und dann bekommt ihr den Fix per Mail.