Editions and features support of sql server 2008

	Enterprise	Standard	Express
Number of CPUs	8	4	1
Maximum memory utilized	2 TB	64 GB	1 GB
Maximum database size	524 PB	524 PB	10 GB
Table and index partitioning	Yes	Yes	No
Automatic use of indexed views by query optimizer	Yes	No	No
Log shipping	Yes	Yes	No
Database mirroring	Yes	Yes	No
Backup compression	Yes	Yes	No
Online indexing	Yes	No	No
PowerShell support	Yes	Yes	Yes
Database mail	Yes	Yes	No
SQL Server Agent	Yes	Yes	No
Database Engine Tuning Advisor	Yes	Yes	No
SQL Server Profiler	Yes	Yes	No
Common language runtime (CLR) integration	Yes	Yes	Yes
Full-text search	Yes	Yes	No
Data compression	Yes	No	No