A whopping 2 days after my "it'll be here soon", SQL Server 2005 SP2 has shipped.

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

Make sure to also check out the updated Books Online

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx