SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Which SQL Server should I be using?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gaby_58
Starting Member

30 Posts

Posted - 03/13/2014 :  16:52:25  Show Profile  Reply with Quote
Hi All,

Which SQL Server should I be installing on my local computer, should it be Standard or Enterprise?

Thanks for any info

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 03/13/2014 :  16:58:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
It depends. I would probably install Developer edition, but it depends on what you are intending to do. I have Enterprise on my local computers, and that matches what we run in production. In the past when Enterprise wasn't supported on certain desktop operating systems, I used Developer edition. I'm now running Windows 7 locally so Enterprise is good.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3744 Posts

Posted - 03/13/2014 :  16:58:50  Show Profile  Reply with Quote
Assuming you are going to be using it for development purposes - and I am inferring that because you said "local computer" - you should be installing developer edition or express edition. Express edition is free, developer edition can be purchased for a nominal amount. Standard and Enterprise editions are production SKUs and are much more expensive. You cannot use developer edition for production purposes, but it has all the features of every edition. You can use express edition for production purposes, but it has certain limitations - max database size is 10 GB, for example.


Edited by - James K on 03/13/2014 17:00:26
Go to Top of Page

gaby_58
Starting Member

30 Posts

Posted - 03/13/2014 :  17:05:25  Show Profile  Reply with Quote
I will be using for development as well as for BI purpose, so is Standard or Developer version is good?

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 03/13/2014 :  19:32:02  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by gaby_58

I will be using for development as well as for BI purpose, so is Standard or Developer version is good?

Thanks



It depends.

The developers that I work with use Developer edition or Express edition. I use Developer or Enterprise. Production uses Enterprise.

What will production use? What features do you need? What license do you have for your local computer?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000