[MSSQL] SQL Server 2008 R2 SP1 (Service Pack 1)

이것도 찾으려니 귀찮군요... 음... 

Download Service Pack 1 for Microsoft® SQL Server® 2008 R2

Quick details

Version:	10.50.2500.0	Date Published:	7/11/2011
Change Language:	Chinese (Simplified)                                                                                Chinese (Traditional)                                                                                English                                                                                French                                                                                German                                                                                Italian                                                                                Japanese                                                                                Korean                                                                                Portuguese (Brazil)                                                                                Russian                                                                                Spanish

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.

File Name	Size
SQLManagementStudio_x64_ENU.exe	155.0 MB	DOWNLOAD
SQLManagementStudio_x86_ENU.exe	153.0 MB	DOWNLOAD
SQLServer2008R2SP1-KB2528583-IA64-ENU.exe	296.0 MB	DOWNLOAD
SQLServer2008R2SP1-KB2528583-x64-ENU.exe	309.0 MB	DOWNLOAD
SQLServer2008R2SP1-KB2528583-x86-ENU.exe	201.0 MB	DOWNLOAD

Overview

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:

(1) SQL Server 2008 R2 Datacenter Edition 
(2) SQL Server 2008 R2 Enterprise Edition and Developer Edition 
(3) SQL Server 2008 R2 Standard Edition 
(4) SQL Server 2008 R2 Web Edition 
(5) SQL Server 2008 R2 Workgroup Edition 
(6) SQL Server 2008 R2 Express Edition 

Note : SQL Server 2008 R2 Express Editions with SP1 can be obtained from the Microsoft SQL Server 2008 R2 SP1 - Express Edition download site.

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

Fixed various issues:

This update fixes many knowledge base issues that are listed in this Master KB article .

For a detailed list of new features and improvements that are included in SQL Server 2008 R2 SP1, review the What's New Section inRelease Notes. 

Top of page

System requirements

Supported Operating Systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista

• 64-bit systems (x64, ia64)

Ia64

Processor :

Itanium processor or faster (Processor Speed - 1.0 GHz or faster)

Operating System :

• Windows Server 2008 R2
• Windows Server 2008 SP2
• Windows Server 2003 SP2
• Windows Server 2003 R2

Memory :

• Ram : Minimum 1 GB (Recommended 4 GB or more)

X64

Processor :

Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support (Processor Speed - 1.0 GHz or faster)

Operating System :

• Windows Server 2003 SP2
• Windows Server 2003 R2 SP2
• Windows Server 2008 SP2
• Windows 2008 R2
• Windows Server 2008 R2

Memory :

• Ram : Minimum 1 GB (Recommended 4 GB or more)

32-bit systems (x86)

X86

Processor :

Pentium III-compatible processor or faster (Processor Speed - 1.0 GHz or faster)

Operating System :

• Windows Server 2003 SP2
• Windows Server 2003 R2 SP2
• Windows Server 2008 SP2
• Windows Server 2008 R2

Memory :

• Ram : Minimum 1 GB (Recommended 4 GB or more)

Note: SQL Server 2008 R2 Service Pack 1 (SP1) is designed to run on Windows Vista and Windows Server 2008. For more information about Hardware and Software Requirements for Installing SQL Server 2008 R2, Please visit SQL Server 2008 R2 Requirement .

Top of page

Instructions

Note: You must have administrative rights on the computer to install SQL Server 2008 R2 SP1.

Step 1: Download and review the Setup documentation and readme file. 
For known issues, review the Release notes.

Step 2: Download the appropriate package by clicking one of the links above.

• To start the installation immediately, click Run.
• To install SP1 at a later time, click Save.

Top of page

Additional information

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.


If you have questions about SQL Server® 2008 R2 SP1,Please visit the SQL Server® 2008 R2 forums on MSDN.
Your feedback is important. Help improve SQL Server 2008 R2 by submitting bugs to Microsoft® Connect.