question

ramesh 1 avatar image
ramesh 1 asked

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 thanks
sql-server-2008sql-server-2008-r2
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.