Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gaby_58
Starting Member
33 Posts |
 Posted - 2014-03-13 : 16:52:25
|
| 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
38200 Posts |
Posted - 2014-03-13 : 16:58:48
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-03-13 : 16:58:50
|
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. |
|
|
|
gaby_58
Starting Member
33 Posts |
Posted - 2014-03-13 : 17:05:25
|
| I will be using for development as well as for BI purpose, so is Standard or Developer version is good?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-13 : 19:32:02
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Which SQL Server should I be using?