Depends on version Microsoft released different
types of editions.
SQL Server offers the right edition to meet
your needs, including Enterprise for mission critical applications, enterprise
business intelligence and data warehousing; Business Intelligence for self-service
and corporate business intelligence; and Standard for basic database, reporting
and analytics capabilities.
In SQL Server 2012 there are several types of
editions are released.
- ·
Enterprise Edition
- ·
Standard Edition.
- ·
Business Edition.
- ·
Express Edition.
- ·
Web and Developer Editions.
Enterprise
Edition:
SQL Server 2012 Enterprise Edition is the high
end of the SQL Server 2012 product line up. It supports the maximum number of
cores and RAM in the host OS and provides the complete SQL Server feature set,
including support for all of the advanced availability and BI features.
The Enterprise edition supports up to 16-node AlwaysOn Failover Clusters
as well as AlwaysOn Availability Groups, online operations, PowerPivot, Power
View, Master Data Services, advanced auditing, transparent data encryption, the
Column Store index, and more. The Enterprise edition is licensed per core.
Standard
Edition:
SQL Server 2012 Standard Edition is limited to 16 cores and 64GB of RAM.
It provides the core relational database engine and basic business intelligence
(BI) capabilities. It doesn't include support for the advanced availability
features or the more powerful BI features such as PowerPivot, Power View, and
Master Data Services. The Standard Edition does include support for two-node
AlwaysOn Failover Clusters, and it's licensed either per core or per server.
Business
Edition:
SQL Server 2012 Business Intelligence Edition is a new member of the SQL
Server family. Like the Standard edition, the Business Intelligence edition is
limited to 16 cores for the database engine and 64GB of RAM. However, it can
use the maximum number of cores supported by the OS for Analysis Services and
Reporting Services. The Business Intelligence edition includes all of the
features in the Standard edition and support for advanced BI features such as
Power View and PowerPivot, but it lacks support for the advanced availability
features like AlwaysOn Availability Groups and other online operations. The
Business Intelligence edition supports two-node AlwaysOn Failover Clusters, and
it's licensed per server.
Express
Edition:
SQL Server 2012 will continue to offer three
versions of the free SQL Server Express Edition: Express (Database Only), Express with Tools, and Express
with Advanced Services. Microsoft will also continue to offer a download of SQL
Server Management Studio Express. The Express editions are limited to support
for one CPU and 1GB of RAM. Databases are limited to 10GB per database. In
addition, a new option called LocalDB will also be available.
Web and Developer Edition:
SQL Server 2012 Web Edition and SQL Server 2012
Developer Edition will continue to be part of the SQL Server 2012 family. The
Developer edition provides the same feature set as the Enterprise edition.
However, it's licensed per developer and can't be used for production work. The
Web edition is licensed only to hosting companies with a Services Provider
License Agreement (SLPA).
There are two types of databases in SQL server
they are system databases and User databases.
--By Shivasagar V
