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
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.
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