Datasheet

Database Features by Edition
The main benefit from one edition of SQL Server to the next are the features enabled. In the following set
of grids, you can see how the features line up to each other across the various editions. These grids do
not capture all the features of SQL Server but instead focus on areas that we receive common questions
about and areas that help distinguish the editions.
Developer Features by Edition
SQL Server 2005 really tries to appeal to the developer. It has many features that will improve the effi-
ciency of the developer’s day-to-day job or make his or her code more reliable. In most cases, you can
see that the developer slate of features works across all the various editions.
Feature SQL Express Workgroup Standard Enterprise
CLR Integration ✓✓✓✓
XML Data Type ✓✓✓✓
Try...Catch Exception Handling ✓✓✓✓
Service Broker Client Only ✓✓✓
Business Intelligence Features by Edition
The fastest-growth area for SQL Server revolves around business intelligence. Business intelligence
allows you to bring the large amounts of data you have in your systems to the mass of users that would
normally not touch this data.
Feature SQL Express Workgroup Standard Enterprise
Analysis Services (SSAS) Up to 16 Yesup to 50
instances instances
SSAS Clustering 2 nodes
✓
Parallelism for Data Mining
Model Processing
✓
SSAS Data Mining ✓✓
SSAS Perspectives ✓
SSAS Translations ✓
SSAS Proactive Caching ✓
Partitioned Cubes ✓
Reporting Services ✓✓✓✓
Report Caching ✓✓
Report Scheduling ✓✓
14
Chapter 1
04_055200 ch01.qxp 10/31/06 12:37 PM Page 14