Compare Edition Features

Scalability & Performance

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Scalability & Performance
Number of CPUs	OS Maximum	4 CPU	2 CPU	4 CPU (Web Workloads Only)	1 CPU
Memory Utilization	OS Maximum	OS Maximum	4 GB Ram	OS Maximum	1 GB Ram
Database Size	524TB	524TB	524TB	524TB	4GB
x32 Hardware Support
x64 Hardware Support
Data Compression
Resource Governor
IA64 hardware support
Table and Index Partitioning
Parallel Index Operations
Parallel Consistency Checks (DBCC)
Scalable Shared Databases
Indexed views
Enhanced Read-ahead and Scan

High Availability (Always On)

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
High Availability (Always On)
Database Mirroring	Yes (full)	Yes (Single Threaded, Safety Full Only)	Witness only	Witness only	Witness only
Online System Changes
Log Shipping
Clustering	16-node failover clustering	2-node failover clustering
Automatic Corruption Recovery from Mirror
Log Stream Compression
Online Indexing
Mirrored Backups
Resource Governor
Backup Compression
Hot-add Memory and CPU Support
Database Snapshots
Fast Recovery
Online Page and File Restore

Replication

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Replication
SQL Server Change Tracking
Merge Replication			Subscriber only **	Subscriber only	Subscriber only
Transactional Replication			Subscriber only **	Subscriber only	Subscriber only
Snapshot Replication			Subscriber only **	Subscriber only	Subscriber only
Heterogeneous Subscribers
Oracle Publishing

Enterprise Security

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Enterprise Security
C2 Complaint Tracing
SQL Audit
Transparent Database Encryption
Extensible Key Management

Enterprise Manageability

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Enterprise Manageability
Hypervisor Support
Database Migration Tools
Policy-Based Management
SQL Server Management Studio Tools					*
Database Mail
Performance Data Collection
SQL Server Agent
Database Tuning Advisor
Plan Guides
SQL Profiler
Standard Performance Reports
Distributed Partition Views
Parallel Index Operations
Automatic Query-to-index-View Matching
Unlimited Virtualization

Data Warehousing

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Data Warehousing
Create Cubes Without a Database
Auto-generate Staging and Datawarehouse Schema
Attribute Relationship Designer
Efficient Aggregation Designers
Scalable read-only AS
Partitioned Cubes
Distributed Partitioned Cubes
Data Compression
Star Join Query Optimizations
Change Data Capture (CDC)

Integration Services

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Integration Services
SQL Server Import and Export Wizard
Log Providers and Logging
XML Source
SSIS Run-time
Basic Data Profiling Tools
SSIS Package Designer & Service
Data Mining Query Transformation
Data Mining Model Training Destination Adapter
Fuzzy Grouping Transformation
Fuzzy Lookup Transformation
Term Extraction Transformation
Dimension Processing Destination Adapter
Partition Processing Destination Adapter

Reporting Services

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Reporting Services
Reporting Services Memory Limits	OS Max	OS Max	4GB	4GB	4GB
Report Designer					*
Report Manager				(report manager)	* (report manager)
Role-based Security			(fixed roles)	(fixed roles)	* (fixed roles)
Basic Data Profiling Tools
Export to Excel, Word, PDF and Images					*
Report Server Application Embedding					*
Enhanced Gauges and Charting
Custom Authentication
Ad-hoc Reporting (Report Builder)
SharePoint Integration
Email and File Share Delivery
Report History, Scheduling, Subscriptions and Caching
Data Source, Delivery and Rendering Extensibility
Scale-out Operational Report Configuration
Data-driven Report Subscriptions
Report Scale-out Deployment
Infinite Click-through in Ad-hoc Reports

Analysis Services

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Analysis Services
Analysis Services Backup
Dimension, Attribute Relationship, Aggregate & Cube Design
Personalization Extensions
Analysis Services Scalable Shared Databases
Account Intelligence
Linked Measures and Dimensions
Perspectives
Semi-additive Measures
Writeback Dimensions
Partitioned Cubes and Distributed Partitioned Cubes
Custom Rollups

Data Mining

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Data Mining
Excel 2007 and Visio 2007 Add-in Support
Comprehensive Set of DM Algorithms
Integrated Data Mining Tools (Wizards, Editors, Model Viewers, Query Builder)
Parallel Model Processing
Cross Validation
Support for Plug-in Algorithms
Advanced Configuration and Tuning Options for Data Mining Algorithms
Support for Pipeline Data Mining and Text Mining with Integration Services
Sequence Prediction

Programmability

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Programmability
MERGE and Upsert Capabilities
New Date and Time Data Types
Internationalization Support
Full Text Search					*
Common Language Runtime (CLR) Integration
Native XML Support
XML Indexing
FILESTREAM Support
Entity Framework Support
Spatial Support

Development Tools

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Development Tools
Microsoft Visual Studio Integration
Intellisense (Transact-SQL-and MDX)
MDX Edit, Debug and Design Tools

Spatial and Location Services

Key: = Full =Partial/Limited

Detailed Feature Comparison	Core Editions		Specialized Editions
	Enterprise	Standard	Workgroup	Web	Express
Spatial and Location Services
Spatial Indexes
Geodetic Data Type
Advanced Spatial Libraries
Standards-based Spatial Support

* Available in SQL Server 2008 Express with Advanced Services Download vs. SQL Server 2008 Express Download.

** If an instance of Workgroup is used as a Publisher, it supports a maximum of 25 publications to all merge subscriptions. It supports an unlimited number of subscriptions to snapshot publications.