x

SQL Server 2008 Editions

Seeder question: I can see that SQL Server 2008 offers no less than 7 editions (not counting the forthcoming SQL Data Services).

If I'm just getting started with MS SQL Server, how do I go about deciding which edition is the one for me?

more ▼

asked Oct 15, 2009 at 08:00 AM in Default

Ben Adderson gravatar image

Ben Adderson ♦♦
361 5 7 8

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

It really depends on what you mean by "me." If by "me" you mean you personally, then I recommend getting a copy of the developer's edition of SQL Server. I believe it costs $50 retail. If you get the developers edition, you'll be limited on the number of connections, the size of server, and the size of databases, but you'll get full functionality of every single aspect of SQL Server. This allows you to develop against and learn about all the various possible options available to you through SQL Server.

If "me" means your business, then you simply need to evaluate the options available in each of the various versions to determine which ones you're likely to take advantage of in the near term. If you don't need all that the Enterprise version offers, get the Standard version or something else.

more ▼

answered Oct 15, 2009 at 09:04 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.8k 19 21 74

Just to note - size of database isn't limited in developer edition - but obviously the licensing model prohibits it's use for anything more than development or testing.
Oct 15, 2009 at 04:05 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

I guess it depends on what you mean by, just getting started with SQL Server, if you mean that you are just starting to learn it and want to get an understanding of it, I would recommend the Developer Edition, which has all the bells and whistles that are included with the Enterprise Edition. Alternatively, you could get your feet wet with the Express Edition which is the free version.

If on the other hand by deciding which version is for you, you mean as for implementing as a database for a business solution - that would really depend on the needs of the business.

more ▼

answered Oct 15, 2009 at 09:08 AM

Jay Bonk gravatar image

Jay Bonk
1.4k 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1834
x14

asked: Oct 15, 2009 at 08:00 AM

Seen: 1277 times

Last Updated: Oct 15, 2009 at 08:00 AM