SQL Server 2008 Service Pack 1 Cumulative Update 1

SQL Server 2008 SP以及累计更新包之间的关系还真的有点乱。

SQL Server 2008 SP1刚刚发布，现在没几天出来一个CU1 for SP1。

目前的这个CU1是将之前SQL Server 2008 CU4的Hotfix补漏到了SQL Server 2008 SP1当中，因为在SQL Server 2008 SP1中并不包含SQL Server 2008 CU4的所有Hotfix。

因为按照微软的说法，SQL Server 2008 SP1与CU4 for SQL Server 2008 RTM只重叠6个hotfix ,参见http://blogs.msdn.com/psssql/archive/2009/04/09/sql-server-2008-sp1-and-cumulative-updates-explained.aspx。

962900

(http://support.microsoft.com/kb/962900/ )

FIX: Error message when you run a query that involves an outer join operation in SQL Server 2008: "Attempting to set a non-NULL-able column's value to NULL"

968693

(http://support.microsoft.com/kb/968693/ )

FIX: A query that uses parameters and the RECOMPILE option returns incorrect result when it is run in multiple connections concurrently in SQL Server 2008

963070

(http://support.microsoft.com/kb/963070/ )
FIX: You cannot edit or debug a SSIS package in BIDS when SQL Server 2008 Enterprise Edition, Standard Edition, Developer Edition or Evaluation edition is installed without the SSIS feature.

961633

(http://support.microsoft.com/kb/961633/ )

FIX: A SQL Server 2008 Reporting Services report is displayed incorrectly in Mozilla Firefox if the report is displayed by using the ReportViewer control

963658

(http://support.microsoft.com/kb/963658/ )
FIX: PAGE compression is removed from a SQL Server 2008 data table after you shrink the database

967470

(http://support.microsoft.com/kb/967470/ )
FIX: Error message when you perform an update or a delete operation on the table that does not have a clustered index created in SQL Server 2008: "The operating system returned error 1450"

 

也就是说，如果你更新到CU4 for SQL Server 2008 RTM是为了解决上面6个问题中的某个，那么你更新SQL Server 2008 SP1之后，这些hotfix仍然有效，但如果你更新CU4 for SQL 2008 RTM是因为其他的hotfix，那么请不要更新SP1。

 

是不是有点绕，简单点来说，微软这么做是为了那些一直持续进行SQL Server 2008 CU1 / CU2 / CU3 / CU 4更新上来的那些同志们服务的。

SQL Server 2008 SP1就是包含了SQL Server 2008 CU1/CU2/CU3的Hotfix（也包含6个CU4 hotfix）。

 

SQL Server 2008 SP1：

http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

 

SQL Server 2008 Service Pack 1 Cumulative Update 1下载地址：

http://support.microsoft.com/kb/969099/en-us

 

SQL Server 2008 RTM之后的Build版本变化：

http://support.microsoft.com/kb/956909/en-us

 

更清晰点可以看这幅图：

 

（点击上图可以看大图）