Geeks With Blogs

News invisible hit counter View My Stats
Technical Speaking

image

Compare SQL Server Enterprise and Standard Editions

Features

Enterprise

Standard

Maximum number of cores

OS Max

16 cores

Maximum size

524 PB

524 PB

Programmability (T-SQL, data types, FileTable)

X

X

SQL Server Management Studio

X

X

Policy-based management

X

X

Basic OLTP

X

X

Basic security (Separation of duties, basic auditing)

X

X

Basic high availability 4

X

X

Built-in data connectors

X

X

Basic data integration (SSIS, designer transforms)

X

X

Basic reporting

X

X

Basic corporate BI (Reporting, analytics, multidimensional semantic model, data mining)

X

X

Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server)

X

 

Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining)

X

 

Enterprise data management (Data Quality Services, Master Data Services)

X

 

Advanced data integration (Fuzzy grouping and lookup, change data capture)

X

 

Data warehousing (In-memory columnstore, compression, partitioning)

X

 

Advanced security (SQL Server audit, transparent data encryption)

X

 

Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering)

X

 

Advanced transaction processing (In-memory OLTP)

X

 

 

1 Analysis Services & Reporting Services.

2 Available in Express with Tools or as standalone download.

3 Full text search available in Express with Advanced Services.

4 Basic includes log shipping, database mirroring, Windows Server Core support and two-node Failover Clustering.

5 Available in Express with Advanced Services.

Find details comparison http://msdn.microsoft.com/en-us/library/cc645993.aspx

Posted on Friday, February 20, 2015 6:43 AM | Back to top


Comments on this post: Compare SQL Server Enterprise and Standard Editions

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © MJ Ferdous | Powered by: GeeksWithBlogs.net