Overview of SQL Server 2014 Editions

: Each SQL Server edition is targeted to a specific business use case as shown in the following table:

Parallel Data Warehouse
Uses massively parallel processing (MPP) to execute queries against vast amount of data quickly. Parallel Data Warehouse systems are sold as a complete "appliance" rather than via standard software licenses.

Enterprise
Provides the highest levels of reliability for demanding workloads.

Business Intelligence
Adds Business Intelligence to the offerings from Standard Edition.

Standard
Delivers a reliable, complete data management platform.

Express
A free edition for lightweight web and small server-based applications.

Compact 
A free edition for standalone and occasionally connected mobile applications, optimized for a very small memory footprint

Developer 
Includes all of the features of Enterprise edition, but is licensed only to allow developers to build, test, and demonstrate SQL Server applications.

Web
A secure, cost effective, and scalable platform for public web sites and applications