asked on

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.

ASKER CERTIFIED SOLUTION

chaau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike Eghtebas

ASKER

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).

chaau

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

chaau

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)

SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial