Generally, a download manager enables downloading of large files or multiples files in one session.Many web browsers, such as Internet Explorer 9, include a download manager.Stand-alone download managers also are available, including the Microsoft Download Manager.

if you do not have a download manager installed, and still want to download the file(s) you've chosen, please note:

You may not be able to download multiple files at the same time.In this case, you will have to download the files individually.(You would have the opportunity to download individual files on the "Thank you for downloading" page after completing your download.)

Files larger than 1 GB may take much longer to download and might not download correctly.

You might not be able to pause the active downloads or resume downloads that have failed.

The Microsoft Download Manager solves these potential problems.It gives you the ability to download multiple files at one time and download large files quickly and reliably.It also allows you to suspend active downloads and resume downloads that have failed.

Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.

Version:

10.50.2500.0

File Name:

SQLServer2008R2SP1-KB2528583-IA64-ENU.exe

SQLManagementStudio_x64_ENU.exe

SQLManagementStudio_x86_ENU.exe

SQLServer2008R2SP1-KB2528583-x64-ENU.exe

SQLServer2008R2SP1-KB2528583-x86-ENU.exe

Date Published:

7/11/2011

File Size:

296.5 MB

155.9 MB

153.1 MB

309.0 MB

201.1 MB

SQL Server 2008 R2 Service Pack 1(SP1) is now available for download. SQL Server 2008 R2 service packs are cumulative updates and upgrade all service levels of SQL Server 2008 R2 to SP1. This service pack contains the cumulative updates of SQL Server 2008 R2 cumulative update packages 1 thru 6. You can use these packages to upgrade any of the following SQL Server 2008 R2 editions:

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.

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

The following describe additional use terms for the software. This supplemental and the license terms for the software apply to your use of the software. If there is a conflict, this supplement applies.

By using the software as described below, you accept these terms. If you do not accept them, you do not have the rights below.

1. Term - The term of the software license terms agreement is extended to June 30, 2013, or commercial release of the software, whichever is first.

2. Time-Sensitive Software - The software may include time-sensitive software. The time-sensitive portions of the software may stop functioning prior to the expiration of the term. Please refer to the software license terms for details.

3. Other Terms - Except as stated in this supplement, the software license terms apply to your use of the software.

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.