Solved

SQL Server 2008 vs SQL Server 2008 R2

Posted on 2011-02-21
2
763 Views
Last Modified: 2012-08-13
Hi Friends,

Is it right that:
For SQL Server 2008 Enterprise Edition, the max memory limit is Operating system maximum while for SQL Server 2008 R2 Enterprise Edition its 2TB (OS max is for Datacenter Edition).
In the same way for SQL Server 2008 EE, the max CPU limit is Operating system maximum while for SQL Server 2008 R2 EE its 8 (OS max is for Datacenter Edition).
0
Comment
Question by:subhashpunia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34941572
There are now 2 new edtions with SQL Server 2008 R2.

DataCentre Edtion
Parallel Data Warehouse Edition
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 34944913
Yes, your statements appear correct. If you need to compare more details, here are the Microsoft sites:

Edition comparison for SQL Server 2008 R2:
http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

Edition comparison for SQL Server 2008:
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question