New Cumulative Updates for SQL Server 2008 are available

SQL Server / SQL Server 2008

January 18^th, 20111

New Cumulative Updates for SQL Server 2008 are available

January 18^th, 20111

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.

By: 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, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

Glenn Berry says:

January 18, 2011 at 7:11 PM

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…