THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

Which Edition of SQL Server 2008 R2 should you use?

SQL Server 2008 R2 has just released to manufacturing (RTM’d) as I write this. With each new release, we make changes to the “Editions” we offer.

A SQL Server “version” deals with the major changes in the product – and “edition” is a set of features and capabilities within that version (you’re welcome).

So… definitely run over to and check out the changes. For instance, did you know that SQL Server Express now supports 10GB databases? Well, then get over there and read what each edition does.

Published Wednesday, April 21, 2010 8:03 AM by BuckWoody



Chris Wood said:


Seems that you now need Datacenter for servers with more than 8 cores if I read the chart right as against OS max in SQL2008 and SQL2005 with Enterprise.


April 21, 2010 12:39 PM

noeldr said:


That, is the number of "Sockets" not the number of "cores".

I know, is easily misunderstood.

April 21, 2010 1:30 PM

Chris Wood said:

Thanks Noeldr. I did mean to say sockets so as long as you don't have servers with more than 8 sockets you can fully utilize the server with SQL2008R2 Enterprise Edition.


April 21, 2010 2:00 PM

dan said:

Looks like the maximum memory support by sql server R2 standard edition is 64 GB where as it was OS maximum in sql server 2008.

April 21, 2010 5:23 PM

noeldr said:

Good Point dan!

If they limited EE I am not surprised that they would limit Standard as well... Definitely they are getting greedy.

Oh and one more thing they upped the prices of all paid versions ;-)

April 21, 2010 7:05 PM

jwhite said:

So 2008 R2 Enterprise will be able to support more than 64 logical processors as long as there are no more than 8 physical processors?  If so that's pretty significant news as up until this point all indications I had seen were that in order scale to, for example 96 Opteron cores, R2 Datacenter and its processor licensing only model would be required.  

April 22, 2010 10:06 AM
New Comments to this post are disabled

About BuckWoody

This Blog


Privacy Statement