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?")

SQL Server 2008 SP1 Cumulative Update #12 – build #10.0.2808

SQL Server 2008 SP2 Cumulative Update #2 – build #10.0.4272

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.