SQL2008r2 editions compared

From XLS Hosting Wiki

Source: http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

Scalability and performance:

	Enterprise	Standard	Web	Workgroup	Express
Number of CPU's	8	4	4	2	1
Maximum memory utilized	2 TB	64 GB	64 GB	4 GB	1 GB
Maximum database site	524 PB	524 PB	524 PB	524 PB	10 GB

High availability:

	Enterprise	Standard	Web	Workgroup	Express
Online system changes	YES	YES	YES	YES	YES
Log shipping	YES	YES	YES	YES	NO
Database mirroring2	YES	YES	NO	NO	NO
Automatic corruption recovery from mirror	YES	YES	NO	NO	NO
Log stream compression	YES	YES	NO	NO	NO
Number of Failover clustering nodes	16	2	NO	NO	NO

Management tools:

	Enterprise	Standard	Web	Workgroup	Express
SQL Server Configuration Manager	YES	YES	YES	YES	YES
SQL CMD (command prompt tool)	YES	YES	YES	YES	YES
Database mirroring2	YES	YES	YES	YES	YES
SQL Server Migration Assistant1	YES	YES	YES	YES	NO
SQL Server Management Studio2	YES	YES	YES	YES	NO
SQL Server Agent	YES	YES	YES	YES	NO
Database Engine Tuning Advisor	YES	YES	YES	YES	NO
DSQL Server Profiler	YES	YES	YES	YES	NO
Analysis Services, PowerPivot IT operation dashboard	YES	NO	NO	NO	NO

Replication:

	Enterprise	Standard	Web	Workgroup	Express
Snapshot replication	YES	YES	Subscriber only	YES	Subscriber only
Merge replication	YES	YES	Subscriber only	Restricted	Subscriber only
Transactional replication	YES	YES	Subscriber only	Restricted	Subscriber only
SQL Server change tracking	YES	YES	YES	YES	YES
Publishing data from SQL Server to non SQL Server subscribers	YES	YES	NO	NO	NO
Publishing data from Oracle to SQL Server	YES	NO	NO	NO	NO
Peer to Peer replication	YES	NO	NO	NO	NO