Microsoft SQL Server 2008 Editions and Limitations Overview

Business today demands a different kind of data management solution—one that offers excellent performance, scalability, and reliability, but is also easy to use and maintain. SQL Server 2008 delivers on this by providing a Trusted, Productive and Intelligent Data Platform that can solve your data management needs.

SQL Server 2008 is available in many editions to help meet the needs of your organization (click here to go to Microsoft website).

Enterprise

Standard

Workgroup

Web

Developer

Express

Compact 3.5

Target Scenarios

Enterprise workloads that need redundancy and built-in Business Intelligence

Shared data scenarios in departments and small to large businesses

Remote offices that need local instances of company data

For web application hosting

Full featured edition for development and testing only

Entry level database, ideal for learning and ISV redistribution

Embedded database for developing desktop and mobile applications

CPU

8 CPU

4 CPU

2 CPU

4 CPU

OS Maximum

1 CPU

OS Maximum

Memory

2 TB Ram

64 GB Ram

4 GB

OS Maximum

OS Maximum

1 GB

OS Maximum

DB Size

524PB

524PB

524PB

524PB

524PB

10 GB

4 GB

Feature Comparison by Edition

The below information provides a comparison of key capabilities between SQL Server 2008 Enterprise, Standard, Workgroup, Web and Express editions.

NOTE: The Developer Edition contains the same features as the Enterprise edition and it is inexpensive.

 

Key: clip_image002= Full clip_image003=Partial/Limited

 

 

Scalability & Performance

 

Enterprise

Standard

Workgroup

Web

Express

Scalability & Performance

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

Number of CPUs

8 CPU

4 CPU

2 CPU

4 CPU

(Web Workloads Only)

1 CPU

Memory Utilization

2 TB Ram

64 GB Ram

4 GB Ram

OS Maximum

1 GB Ram

Database Size

524PB

524PB

524PB

524PB

10GB

x32 Hardware Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

x64 Hardware Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Data Compression

clip_image002[1]

       

Resource Governor

clip_image002[1]

       

IA64 hardware support

clip_image002[1]

       

Table and Index Partitioning

clip_image002[1]

       

Parallel Index Operations

clip_image002[1]

       

Parallel Consistency Checks (DBCC)

clip_image002[1]

       

Scalable Shared Databases

clip_image002[1]

       

Indexed views

clip_image002[1]

       

Enhanced Read-ahead and Scan

clip_image002[1]

       

High Availability (Always On)

 

Enterprise

Standard

Workgroup

Web

Express

High Availability (Always On)

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

Database Mirroring

Yes (full)

Yes (Single Threaded, Safety Full Only)

Witness only

Witness only

Witness only

Online System Changes

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Log Shipping

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

Clustering

16-node failover clustering

2-node failover clustering

     

Automatic Corruption Recovery from Mirror

clip_image002[1]

clip_image002[1]

     

Log Stream Compression

clip_image002[1]

clip_image002[1]

     

Online Indexing

clip_image002[1]

       

Mirrored Backups

clip_image002[1]

       

Resource Governor

clip_image002[1]

       

Backup Compression

clip_image002[1]

       

Hot-add Memory and CPU Support

clip_image002[1]

       

Database Snapshots

clip_image002[1]

       

Fast Recovery

clip_image002[1]

       

Online Page and File Restore

clip_image002[1]

       

Replication

 

Enterprise

Standard

Workgroup

Web

Express

Replication

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

SQL Server Change Tracking

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Merge Replication

clip_image002[1]

clip_image002[1]

Subscriber only **

Subscriber only

Subscriber only

Transactional Replication

clip_image002[1]

clip_image002[1]

Subscriber only **

Subscriber only

Subscriber only

Snapshot Replication

clip_image002[1]

clip_image002[1]

Subscriber only **

Subscriber only

Subscriber only

Heterogeneous Subscribers

clip_image002[1]

clip_image002[1]

     

Oracle Publishing

clip_image002[1]

       

Enterprise Security

 

Enterprise

Standard

Workgroup

Web

Express

Enterprise Security

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

C2 Complaint Tracing

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

SQL Audit

clip_image002[1]

       

Transparent Database Encryption

clip_image002[1]

       

Extensible Key Management

clip_image002[1]

       

Enterprise Manageability

 

Enterprise

Standard

Workgroup

Web

Express

Enterprise Manageability

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

Hypervisor Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Database Migration Tools

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Policy-Based Management

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

SQL Server Management Studio Tools

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Database Mail

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

Performance Data Collection

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

SQL Server Agent

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

Database Tuning Advisor

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

Plan Guides

clip_image002[1]

clip_image002[1]

 

clip_image002[1]

 

SQL Profiler

clip_image002[1]

clip_image002[1]

clip_image002[1]

   

Standard Performance Reports

clip_image002[1]

clip_image002[1]

     

Distributed Partition Views

clip_image002[1]

       

Parallel Index Operations

clip_image002[1]

       

Automatic Query-to-index-View Matching

clip_image002[1]

       

Unlimited Virtualization

clip_image002[1]

       

Data Warehousing

 

Enterprise

Standard

Workgroup

Web

Express

Data Warehousing

clip_image002[1]

clip_image003[1]

     

Create Cubes Without a Database

clip_image002[1]

clip_image002[1]

     

Auto-generate Staging and Datawarehouse Schema

clip_image002[1]

clip_image002[1]

     

Attribute Relationship Designer

clip_image002[1]

clip_image002[1]

     

Efficient Aggregation Designers

clip_image002[1]

clip_image002[1]

     

Scalable read-only AS

clip_image002[1]

       

Partitioned Cubes

clip_image002[1]

       

Distributed Partitioned Cubes

clip_image002[1]

       

Data Compression

clip_image002[1]

       

Star Join Query Optimizations

clip_image002[1]

       

Change Data Capture (CDC)

clip_image002[1]

       

Integration Services

 

Enterprise

Standard

Workgroup

Web

Express

Integration Services

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

SQL Server Import and Export Wizard

clip_image002[1]

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

Log Providers and Logging

clip_image002[1]

clip_image002[1]

     

XML Source

clip_image002[1]

clip_image002[1]

     

SSIS Run-time

clip_image002[1]

clip_image002[1]

     

Basic Data Profiling Tools

clip_image002[1]

clip_image002[1]

     

SSIS Package Designer & Service

clip_image002[1]

clip_image002[1]

     

Data Mining Query Transformation

clip_image002[1]

       

Data Mining Model Training Destination Adapter

clip_image002[1]

       

Fuzzy Grouping Transformation

clip_image002[1]

       

Fuzzy Lookup Transformation

clip_image002[1]

       

Term Extraction Transformation

clip_image002[1]

       

Dimension Processing Destination Adapter

clip_image002[1]

       

Partition Processing Destination Adapter

clip_image002[1]

       

Reporting Services

 

Enterprise

Standard

Workgroup

Web

Express

Reporting Services

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

Reporting Services Memory Limits

OS Max

OS Max

4GB

4GB

4GB

Report Designer

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Report Manager

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Role-based Security

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Basic Data Profiling Tools

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Export to Excel, Word, PDF and Images

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Report Server Application Embedding

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Enhanced Gauges and Charting

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

Custom Authentication

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

 

Ad-hoc Reporting (Report Builder)

clip_image002[1]

clip_image002[1]

clip_image002[1]

   

SharePoint Integration

clip_image002[1]

clip_image002[1]

     

Email and File Share Delivery

clip_image002[1]

clip_image002[1]

     

Report History, Scheduling, Subscriptions and Caching

clip_image002[1]

clip_image002[1]

     

Data Source, Delivery and Rendering Extensibility

clip_image002[1]

clip_image002[1]

     

Scale-out Operational Report Configuration

clip_image002[1]

       

Data-driven Report Subscriptions

clip_image002[1]

       

Report Scale-out Deployment

clip_image002[1]

       

Infinite Click-through in Ad-hoc Reports

clip_image002[1]

       

Analysis Services

 

Enterprise

Standard

Workgroup

Web

Express

Analysis Services

clip_image002[1]

clip_image003[1]

     

Analysis Services Backup

clip_image002[1]

clip_image002[1]

     

Dimension, Attribute Relationship, Aggregate & Cube Design

clip_image002[1]

clip_image002[1]

     

Personalization Extensions

clip_image002[1]

clip_image002[1]

     

Analysis Services Scalable Shared Databases

clip_image002[1]

       

Account Intelligence

clip_image002[1]

       

Linked Measures and Dimensions

clip_image002[1]

       

Perspectives

clip_image002[1]

       

Semi-additive Measures

clip_image002[1]

       

Writeback Dimensions

clip_image002[1]

       

Partitioned Cubes and Distributed Partitioned Cubes

clip_image002[1]

       

Custom Rollups

clip_image002[1]

       

Data Mining

 

Enterprise

Standard

Workgroup

Web

Express

Data Mining

clip_image002[1]

clip_image003[1]

     

Excel 2007 and Visio 2007 Add-in Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

     

Comprehensive Set of DM Algorithms

clip_image002[1]

clip_image002[1]

     

Integrated Data Mining Tools (Wizards, Editors, Model Viewers, Query Builder)

clip_image002[1]

clip_image002[1]

     

Parallel Model Processing

clip_image002[1]

       

Cross Validation

clip_image002[1]

       

Support for Plug-in Algorithms

clip_image002[1]

       

Advanced Configuration and Tuning Options for Data Mining Algorithms

clip_image002[1]

       

Support for Pipeline Data Mining and Text Mining with Integration Services

clip_image002[1]

       

Sequence Prediction

clip_image002[1]

       

Programmability

 

Enterprise

Standard

Workgroup

Web

Express

Programmability

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

MERGE and Upsert Capabilities

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

New Date and Time Data Types

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Internationalization Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Full Text Search

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Common Language Runtime (CLR) Integration

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Native XML Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

XML Indexing

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

FILESTREAM Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Entity Framework Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Spatial Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Development Tools

 

Enterprise

Standard

Workgroup

Web

Express

Development Tools

clip_image002[1]

clip_image002[1]

clip_image003[1]

clip_image003[1]

clip_image003[1]

Microsoft Visual Studio Integration

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Intelligence (Transact-SQL-and MDX)

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

MDX Edit, Debug and Design Tools

clip_image002[1]

clip_image002[1]

     

Spatial and Location Services

 

Enterprise

Standard

Workgroup

Web

Express

Spatial and Location Services

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Spatial Indexes

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Geodetic Data Type

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Advanced Spatial Libraries

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

Standards-based Spatial Support

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

clip_image002[1]

* 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.

About onlinejt

Blogger

,

No comments yet.

Leave a Reply

*