Two new cumulative updates for SQL Server 2008 R2 are available!
Last night Microsoft released two new cumulative updates for SQL Server 2008 R2:
Cumulative Update 5 for SQL Server 2008 R2 SP1
- KB #2659694
- Build 10.50.2806
- 16 fixes, including a nasty SCOPE_IDENTITY() bug and several performance fixes.
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.
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.