Notes about SQL Server 2008 R2 SP1


 

Hi,

The purpose of this post is to share some notes (links) about the recent release of SQL Server 2008 R2 SP1:

SQL Server 2008 R2 SP1    

     
Download    
http://www.microsoft.com/download/en/details.aspx?id=26727    
     
List of bugs that are fixed in SQL Server 2008 R2 SP1    
http://support.microsoft.com/kb/2528583    
     
SQL Server 2008 R2 SP1 - Express    
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26729    
     

What's new ?

   
     
Topic Description Link
Dynamic Management Views (DMVs) 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.
http://blogs.msdn.com/b/sqlosteam/archive/2011/05/11/more-on-dmv-changes-in-sql-2008-r2-sp1.aspx

Link from BOL (example) – sys.dm_os_volume_stats(,)  - http://msdn.microsoft.com/en-us/library/hh223223.aspx

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. http://msdn.microsoft.com/en-us/library/ms181714.aspx
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 - http://go.microsoft.com/fwlink/?LinkId=199000. http://msdn.microsoft.com/en-us/library/ee634742.aspx
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 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.  http://msdn.microsoft.com/en-us/library/ee210546.aspx
Support for 15K partitions on a database.
In SQL Server 2008 and SQL Server 2008 R2, the number of partitions on tables and indexes is limited to 1,000. This paper discusses how SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 address this limitation by providing an option to increase the limit to 15,000 partitions. It describes how support for 15,000 partitions can be enabled and disabled on a database.
http://msdn.microsoft.com/en-us/library/gg981694.aspx
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. http://blogs.msdn.com/b/psssql/archive/2011/01/13/sql-server-new-drives-use-4k-sector-size.aspx
     
Slipstream  
http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx  
     
Cumulative Updates  
http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/06/21/cumulative-updates-included-in-sql-server-2008-r2-sp1.aspx  
     
Readme  
http://social.technet.microsoft.com/wiki/contents/articles/microsoft-sql-server-2008-r2-sp1-readme.aspx  
     
Feature Pack    
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26728    
     
Release Notes  
http://social.technet.microsoft.com/wiki/contents/articles/microsoft-sql-server-2008-r2-sp1-release-notes.aspx  
     

Cheers,

Comments (1)

  1. office Professional plus says:

    IT professionals collaborate for increased website optimization with optimum safety and protection for your internet site for

    <a href="http://www.professionalplus2010.com">office Professional plus</a> enhanced business enterprise options. ms office professional plus 2010 product key offers you a different this kind of enhanced security characteristics as the "Trusted Documents" and "Protective View." Automated scanning of<a href="http://www.buyoutlook2010.com/">outlook 2010 online</a> paperwork greatly improves your security entry on the web. You are then advised about <a href="http://www.professionalplus2010.com">office Professional plus</a>certain web sites and files that could harm your technique or website despite the fact that you are also provided the "Retention Policy" solution to proceed to these kinds of<a href="http://www.buyoutlook2010.com/">outlook 2010</a> sites or files anyway whenever you want to.

Skip to main content