Hi friends,
I want to know that , What is the difference between SQL Server 2008 & SQL Server 2008 R2 ?
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 15, 2011, 11:48 PM
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 DwijPosted Nov 24, 2011, 4:20 PM
Kunal NaikPosted Nov 15, 2011, 11:09 PM
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