differences between sql server 2008 and sql server 2008 r2

hi pal's we are upgrading from sql server 2005 to sql server 2008, i am in need to find out which vesrsion of sql server 2008 is best to follow, we are using 64 bit os, is it good to use sql server 2008 or sql server 2008 r2.

which of these versions are best to be used

more ▼

asked Jul 20, 2010 at 12:59 AM in Default

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
As a general rule, for pretty much any system, use the one that has the functionality that you need. If both have the same, use the one that has a service pack released.
more ▼

answered Jul 20, 2010 at 01:56 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(comments are locked)
10|1200 characters needed characters left
For most purposes there is little difference between 2008 and R2, but if you're doing a brand new install, I'd go straight to R2. While there are few functional differences, there are some bug fixes that are incorporated into R2 that won't be available in 2008 until the next service pack. R2 is effectively just a big service pack anyway. I'd go with that one for a new install, but wouldn't sweat moving other 2008 instances to it.
more ▼

answered Jul 20, 2010 at 04:15 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left

If your priority is for Business Intelligence then you should go for SQL Server 2008 R2 Edition. There are lot of new functionality available in R2 edition like Excel 2010 can act as a client for SSAS etc

In Database engine part of R2 edition a new feature is added called "Utility Control Point (UCP)" - for multi-server administration, the SQL Server Utility enables database administrators to centralize their focus and efforts across numerous database applications and SQL instances using a single management interface

There is not that much T-SQL enhancement in SQL Server 2008 R2

more ▼

answered Jul 20, 2010 at 01:38 AM

Cyborg gravatar image

10.6k 36 40 45

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 20, 2010 at 12:59 AM

Seen: 5437 times

Last Updated: Jul 20, 2010 at 02:29 AM