SQL 2008 Features

The following has been reproduced from SQL Server 2008 SP1 Books Online:

Use the following tables to determine which features are supported by the various editions of Microsoft SQL Server 2008.

Note:
SQL Server Enterprise is available in an Evaluation edition for a 180-day trial period. For more information about how to obtain an evaluation copy of SQL Server 2008, see this Microsoft Web site

 

Scalability

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Partitioning Yes          
Data compression Yes          
Resource governor Yes          
Partition table parallelism Yes          

High Availability

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Multi-instance support 50 16 16 16 16 16
Online system changes Yes Yes Yes Yes Yes Yes
Backup log shipping Yes Yes Yes Yes    
Database mirroring Yes (full) Yes (safety full only) Witness only Witness only Witness only Witness only
Failover clustering OS maximum1 2 nodes        
Dynamic AWE Yes Yes        
Failover without client configuration Yes Yes        
Automatic corruption recovery from mirror Yes Yes        
Database snapshots Yes          
Fast recovery Yes          
Online indexing Yes          
Online restore Yes          
Mirrored backups Yes          
Hot add memory Yes          
Online configuration of P2P nodes Yes          
Hot add CPU Yes          
Backup compression Yes          

1Windows Server 2003 supports a maximum of 8 failover cluster nodes. Windows Server 2008 supports a maximum of 64 failover cluster nodes.

Security

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
C2 compliant tracing Yes Yes Yes Yes Yes Yes
SQL auditing foundation Yes Yes Yes Yes Yes Yes
Fine grained auditing Yes          
Transparent database encryption Yes          
ISV encryption (off-box key management) Yes          

Replication

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Merge replication Yes Yes Subscriber only Subscriber only Subscriber only Subscriber only
Transactional replication Yes Yes Subscriber only Subscriber only Subscriber only Subscriber only
Snapshot replication Yes Yes Subscriber only Subscriber only Subscriber only Subscriber only
SQL Server change tracking Yes Yes Yes Yes Yes Yes
Heterogeneous subscribers Yes Yes        
Oracle publishing Yes          
P2P transactional replication Yes          

Manageability

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
User instances         Yes Yes
Dedicated admin connection Yes Yes Yes Yes Yes (Under trace flag) Yes (Under trace flag)
Policy-based configuration Yes Yes Yes Yes Yes Yes
Policy-based management Yes Yes Yes Yes Yes Yes
Performance data collection and warehouse Yes Yes Yes Yes    
Standard performance reports Yes Yes        
Plan guides Yes Yes        
Plan freezing for plan guides Yes Yes        
Policy-based best practices Yes Yes        
Multi-server policy-based management Yes Yes        
Distributed partition views Yes          
Parallel index operations Yes          
Automatic query-to-indexed-view matching Yes          
Parallel database backup checksum check Yes          
Database mail Yes Yes Yes Yes    
Database migration tools Yes Yes Yes Yes Yes Yes

Management Tools

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
SQL management objects (SMO) Yes Yes Yes Yes Yes Yes
SQL Configuration Manager Yes Yes Yes Yes Yes Yes
SQL CMD (command prompt tool) Yes Yes Yes Yes Yes Yes
SQL Server Management Studio Yes Yes Yes Yes (Express version)   Yes (Express version)
SQL Profiler Yes Yes Yes Yes    
SQL Server Agent Yes Yes Yes Yes    
Database Tuning Advisor Yes Yes Yes Yes    
Microsoft Operations Manager Pack Yes Yes Yes Yes    

Development Tools

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Microsoft Visual Studio Integration Yes Yes Yes Yes Yes Yes
SQL query and edit and design tools Yes Yes Yes      
Intellisense (Transact-SQL and MDX) Yes Yes Yes      
Version control support Yes Yes Yes      
Business Intelligence Development Studio Yes Yes        
MDX edit, debug, and design tools Yes Yes        

Programmability

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Common language runtime (CLR) integration Yes Yes Yes Yes Yes Yes
Native XML support Yes Yes Yes Yes Yes Yes
XML indexing Yes Yes Yes Yes Yes Yes
MERGE and UPSERT capabilities Yes Yes Yes Yes Yes Yes
FILESTREAM support Yes Yes Yes Yes Yes Yes
Date and Time data types Yes Yes Yes Yes Yes Yes
Internationalization support Yes Yes Yes Yes Yes Yes
Full-text search Yes Yes Yes Yes   Yes
Specification of language in query Yes Yes Yes Yes   Yes
Service broker (messaging) Yes Yes Yes Client only Client only Client only
XML/A support Yes Yes        
Web services (HTTP/SOAP endpoints) Yes Yes        

Spatial and Location Services

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Spatial indexes Yes Yes Yes Yes Yes Yes
Geodetic data type Yes Yes Yes Yes Yes Yes
Advanced spatial libraries Yes Yes Yes Yes Yes Yes
Standards-based spatial support Yes Yes Yes Yes Yes Yes

Integration Services

Feature Enterprise Standard Workgroup Web Express Express Advanced
SQL Server Import and Export Wizard with basic sources and destinations and Execute SQL task Yes Yes Yes Yes Yes Yes
Integration Services runtime Yes Yes Yes Yes Yes Yes
Integration Services API and object model Yes Yes Yes Yes    
SSIS Designer including VSTA scripting Yes Yes        
Integration Services service, wizards, and command prompt utilities Yes Yes        
Basic tasks and transformations Yes Yes        
Log providers and logging Yes Yes        
Data profiling tools Yes Yes        
Additional sources and destinations:Raw File sourceXML source

DataReader destination

Raw File destination

Recordset destination

SQL Server Compact destination

SQL Server destination

Yes Yes        
Advanced sources, transformations, and destinations:Data Mining Query transformationFuzzy Lookup and Fuzzy Grouping transformations

Term Extraction and Term Lookup transformations

Data Mining Model Training destination

Dimension Processing destination

Partition Processing destination

Yes          

 

Data Warehouse Creation

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Create cubes without a database Yes Yes        
Auto-generate staging and data warehouse schema Yes Yes        
Attribute relationship designer Yes Yes        
Efficient aggregation designers Yes Yes        

Data Warehouse Scale and Performance

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Change data capture Yes          
Star join query optimization Yes          
Scalable read-only AS configuration Yes          
Proactive caching Yes          
Auto parallel partition processing Yes          
Partitioned cubes Yes          
Distributed partitioned cubes Yes          

Multi-Dimensional Analytics

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
SQL Server Analysis Services service Yes Yes        
SQL Server Analysis Services backup Yes Yes        
General performance/scale improvements Yes Yes        
Dimension, attribute relationship, aggregate, and cube design improvements Yes Yes        
Personalization extensions Yes Yes        
Financial aggregations Yes          
Partitioned customers Yes          
Custom rollups Yes          
Semi-additive measures Yes          
Writeback dimensions Yes          
Linked measures and dimensions Yes          
Binary and compressed XML transport Yes          
Account intelligence Yes          
Perspectives Yes          
Analysis Services shared, scalable databases Yes          

Data Mining

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Standard algorithms Yes Yes        
Data mining tools: wizards, editors, query builders Yes Yes        
Cross validation Yes          
Models on filtered subsets of mining structure data Yes          
Time series: custom blending between ARTXP and ARIMA models Yes          
Time series: prediction with new data Yes          
Unlimited concurrent datamining queries Yes          
Advanced configuration and tuning for algorithms Yes          
Algorithm plug-in API Yes          
Parallel model processing Yes          
Time series: cross-series prediction Yes          
Unlimited attributes for association rules Yes          
Sequence prediction Yes          
Multiple prediction targets for naïve Bayes, neural network, and logistic regression Yes          

Reporting

Feature Name Enterprise Standard Workgroup Web Express Express Advanced
Report server Yes Yes Yes Yes   Yes
Report Designer Yes Yes Yes Yes   Yes
Report Manager Yes Yes Yes Yes (Report Manager)   Yes (Report Manager)
Role-based security Yes Yes Yes (Fixed roles) Yes (Fixed roles)   Yes (Fixed roles)
Ad-hoc reporting (Report builder) Yes Yes Yes      
Word export and enhanced text formatting Yes Yes Yes Yes   Yes
Enterprise-scale reporting engine Yes Yes Yes Yes   Yes
IIS-agnostic report deployment Yes Yes Yes Yes   Yes
Updated management tools Yes Yes Yes Yes   Yes
Report definition customization extension (RDCE) Yes Yes Yes Yes   Yes
SharePoint integration Yes Yes        
Enhanced SSRS gauges and charting Yes Yes Yes Yes   Yes
Custom authentication Yes Yes Yes Yes    
Export to Excel, PDF, and images Yes Yes Yes Yes   Yes
Remote and non-relational data source support Yes Yes        
E-mail and file share delivery Yes Yes        
Report history, scheduling, subscriptions, and caching Yes Yes        
Data source, delivery, and rendering extensibility Yes Yes        
Scale out (Web farms) Yes          
Infinite click-through Yes          
Data-driven subscriptions Yes          
Reporting Services memory limits Unlimited Unlimited 4 GB 4 GB   4 GB