SQL Server 2008 & SQL Server 2008 R2

Question

Hi friends I want to know that  What is the difference between SQL Server 2008 & SQL Server 2008 R2 ? Thanks

Pravin More · Answer

Hi Deepak Microsoft SQL Server 2008 R2 introduces lot many new features for Business Intelligence users Developers and Database Administrators. 1.In SQL Server 2008 R2 the number of logical processors supported has been increased from 64 to 256 and it will take advantage of the multi-core technology. This will help improve performance and scalability for very large data warehousing applications. 2.SQL Server 2008 R2 Optimizes Hardware Resources. 3.In SQL Server 2008 R2 Database Application development will be more closely integrated with Visual Studio 2010 which will help to ensure higher quality during the application development along with easier deployments and better handling of changes over time. Thanks Pravin.

Deepak Dwij · Answer

Thanks Pravin

Kunal Naik · Answer

Hi SQL Server 2008 with and SQL Server 2008 R2 both are same version but different releases. Every application able to get connected and work with SQL Server 2008 should be able to do the same with SQL Server 2008 R2. SQL Server 2008 is limited to 50 instances on a stand-alone server and 25 instances on a failover cluster. Also refer following links Click Here Click Here