September 24, 2010 at 2:22 pm
Has anyone found any issues with the Cumulative Update package 3 for SQL Server 2008 R2?
http://support.microsoft.com/kb/2261464/en-us
I believe this is the latest update of SQL 2008 R2 to-date.
Right now we are on SQL 2008 SP1, and we would like to upgrade to SQL 2008 R2, but not the RTM version.
Thoughts/comments would be welcome.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 24, 2010 at 3:47 pm
Marios, we are running SQL2008 R2 RTM and on a pretty meaty machine. We have had no issues.
I would only apply a CU if you are hitting an issue it addresses.
---------------------------------------------------------------------
September 24, 2010 at 3:50 pm
Also, remember 2008 ---> R2 is not the same as say 2005 ---> 2008. R2 is much more 2008 with extras.
Hence why the versions for SQL2008 are 10.0.nnnn and for SQL2008 R2 10.5.nnnn, not version 11.
---------------------------------------------------------------------
September 24, 2010 at 4:31 pm
george sibbald (9/24/2010)
Also, remember 2008 ---> R2 is not the same as say 2005 ---> 2008. R2 is much more 2008 with extras.Hence why the versions for SQL2008 are 10.0.nnnn and for SQL2008 R2 10.5.nnnn, not version 11.
Hmm, so I should probably stay with the RTM version of SQL 2008 R2 for now. I'd agree, this is what Microsoft is also recommending with their hot fixes as well. I may need to backpedal a little bit, I've already got developers excited about this... 😀
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 24, 2010 at 4:51 pm
last thing you want to do is get developers excited, they can be pesky little critters then....:-)
---------------------------------------------------------------------
September 24, 2010 at 5:02 pm
george sibbald (9/24/2010)
last thing you want to do is get developers excited, they can be pesky little critters then....:-)
Yeah, I'll just have to emphasize the "your applications could break" part over the "look at all these new fixes" part... 😉
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 24, 2010 at 11:53 pm
Marios Philippopoulos (9/24/2010)
Right now we are on SQL 2008 SP1, and we would like to upgrade to SQL 2008 R2, but not the RTM version.Thoughts/comments would be welcome.
What CU if any are you running on SQL Server 2008 SP1? I would just make sure that the fixes you need from that CU are either in the RTM of R2, or that you install the R2 CU that contains the required fixes.
We are currently running SQL Server 2008 R2 CU3 on our development server, and the only problem I have run into is performance regressions when you turn trace flag 4199 on.
September 25, 2010 at 4:40 am
Hi, thanks for responding.
In production we are running on version 10.0.2531, which is the base version of SQL 2008 SP1, ie. no hotfixes.
We had recently updated the dev environment with SQL 2008 R2 (RTM), and it has been running with no issues so far.
Yesterday I built a new prod environment with SQL 2008 R2 RTM, and that's when I realized there were all these cumulative updates since the RTM release.
I think I will wait for SP1 before updating the RTM version of SQL 2008 in production and dev environments.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply