The latest service pack for SQL 2008 - SP3 is now available for
download. Please note this is not for SQL 2008 R2. SQL2008 has
version numbers beginning 10.0 SQL 2008 R2 has version numbers
beginning 10.5
The covering link with notes for the various versions (standard,
express, 32, 64 bit etc.) is here: http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx
One of the major notes is that the install experience has been
improved. I'd still download it in full then apply locally though.
Prerequisites still apply.