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

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.

 

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. I recently joined the team at Wayfair and hope to blog about some of the scale challenges I've already started helping to solve.

1 Response

  1. Glenn Berry says:

    Ah, you beat me again about getting the word out on these. My excuse was that I was off work yesterday due to the holiday…