SQLBlog.org

archives disclaimers
archives shortcuts bad habits
disclaimers
SQLBlog Home
bad habits
shortcuts
MERGE NOLOCK dates dynamic SQL
splitting SQL Server 2022 how to ask

Two new cumulative updates for SQL Server 2008 R2 are available!

Aaron Bertrand SQL Server / SQL Server 2008 R2 1

Last night Microsoft released two new cumulative updates for SQL Server 2008 R2:

Cumulative Update 5 for SQL Server 2008 R2 SP1

My recommendation: You should test and plan for this update if SELECT @@VERSION is between 10.50.2500 and 10.50.2805.

Cumulative Update 12 for SQL Server 2008 R2 (RTM)

  • KB #2659692
  • Build 10.50.1810
  • 3 fixes but none are directly related to the relational engine.

My recommendation: Consider applying if SELECT @@VERSION is between 10.50.1600 and 10.50.1809, you are affected by any of the issues highlighted in the KB article, and you are avoiding Service Pack 1 intentionally (otherwise you should install SP1 and CU5 for SP1).


My usual disclaimer: these updates are NOT for SQL Server 2008. Only apply to systems where @@VERSION returns 10.50.xxxx.

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 father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

1 Response

  1. opc.three says:
    February 28, 2012 at 6:54 PM

    Thanks for posting. This kind of information (especially the emphasis on nasty engine bugs) helps us gain support from management to carve out time to stay current on patch levels in between SPs.