Integrating the CLR into the SQL Server 2005 engine was not done in a trivial way. At the end of the day, SQL Server 2005 has to be a rock-solid implementation of the database.

SP1 encompasses several new features, including database mirroring, in which the primary production server is mirrored at all times by a standby server.