New Cumulative Updates for SQL Server 2008 are available
If you are using SQL Server 2008 SP1 or SP2, the release services team yesterday issued cumulative updates for both branches. (And if you are still on SQL Server 2008 RTM, I can only ask, "Why?")
My favorite fix (well, based on wording alone) appears only in the update for SP2:
"FIX: High CPU usage when you run a SQL Server Agent job in SQL Server 2008 or SQL Server 2008 R2 if a column of a dynamic SELECT statement has a value that is many characters long" (KB #2404865)
Note: these updates are not applicable to SQL Server 2008 R2.