Which version of SQL Server 2014 could

In windows 7 professional, my needs are desktop and asp.net developments. I also will be using SSRS, SSIS, SSAS.

Question: With these needs, which of the followings will best work for me?

You are welcome to include multiple options.

A. Microsoft SQL Server Data Tools for SQL Server 2014 CTP2 32/64-bit (English)    403 KB
B. SQL Server 2014 Business Intelligence 32-bit (English)  1 GB
C. SQL Server 2014 Business Intelligence 64-bit (English)  2 GB
D. SQL Server 2014 Developer Edition 32-bit (English)  1GB
E. SQL Server 2014 Developer Edition 64-bit (English)  2 GB
F. SQL Server 2014 Enterprise Core Edition 32-bit (English)  1 GB
G. SQL Server 2014 Enterprise Core Edition 64-bit (English)  2 GB
H. SQL Server 2014 Enterprise Edition 32-bit (English) 1 GB
I. SQL Server 2014 Enterprise Edition 64-bit (English)  2 GB
J. Microsoft SQL Server 2014 Express 32/64-bit (English) 175 MB
K. SQL Server 2014 Express with Advanced Services 32-bit (English)  1 GB
L. SQL Server 2014 Express with Advanced Services 64-bit (English)  1 GB
M. Microsoft SQL Server 2014 LocaldB 32/64-bit (English) 35 MB
N. SQL Server 2014 LocaldB 64-bit (English) 43 MB
O. SQL Server 2014 Management Studio 32-bit (English)  705 MB
P. SQL Server 2014 Management Studio 64-bit (English) 716 MB
Q. Microsoft SQL Server 2014 Standard Edition 32/64-bit (English)  1 GB
R. SQL Server 2014 Standard Edition 64-bit (English)  2 GB
S. Microsoft SQL Server 2014 Web Edition 32/64-bit (English)  1 GB
T. SQL Server 2014 Web Edition 64-bit (English) 2 GB

Sorry for the long list of options. I was not sure what to exclude.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chaauCommented:
In my opinion you need to install SQL Server Developer edition. It costs a little (nothing if your have a MSDN subscription) but includes everything. You will only be able to use it for development though, not to hold the production data. BTW, according to Wikipedia (I did not verify it):

SQL Server Developer Edition includes the same features as SQL Server 2012 Enterprise Edition, but is limited by the license to be only used as a development and test system, and not as production server. This edition is available to download by students free of charge as a part of Microsoft's DreamSpark program.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
This is for single user just to practice and learn. I want to be able to have all the features possible. For example, partitioning is not possible in all versions; therefor, one can not practice it in some versions. And, there are more features like portioning I am not mentioning here (because I do not know about them at this point).
0
chaauCommented:
As I said: why spending thousands of dollars on the Enterprise edition when you can buy a Developer edition (or have it for free if you are a student). You will have all the features the Enterprise edition has
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

chaauCommented:
BTW, this MSDN page can help you in your decision if you want to buy a fully commercial edition. It looks like Enterprise edition is the most feature-rich (same as the Developer edition)
0
Aneesh RetnakaranDatabase AdministratorCommented:
E. SQL Server 2014 Developer Edition 64-bit (English)  2 GB
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just go for the Developer Edition (32bit or 64bit depending on your Windows 7 version). It has ALL SQL Server features enabled.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.