sql 2005 enterprise edition - sql 2008 enterprise evulation

SQL Server 2005

SQL Server 2008

Section

Product Features

Product Features

Analysis Services

OLAP

Analysis Scale and Performance

Data Mining

Block Computations

KPI Framework

Writeback

MDX

Scale-Out Analysis

Unified Dimensional Model

Sub-Space Computation

Proactive Caching

New Cube designer

BI Development Studio

Translations

Perspectives

Real Time BI

Hetegenerous Data Source Support

Data Warehousing

Relational Data Warehouse

Backup Compression

Multidimensional Data Warehouse

Partitioned Table Parallelism

Proactive Caching

Star Join Query Optimizations

Partitioning

Grouping Sets

Online Index Management

Change Data Capture

Partial Backup and Restore

MERGE SQL Statement

Management Studio

Indexed Views

Query Optimizations

Optimized Statistics

Star Join Optimizations

Shared Scalable Databases

High Availability

Database Mirroring

Enhanced Database Mirroring

Failover Clustering

Automatic Recovery of Data Pages - Mirroring

Peer-to-Peer Transactional Replication

Log Stream Compression

Log Shipping

Peer-to-Peer - Conflict Resolution

Partial Database Availability

Database Snapshots

Online Operations

Fast Database Recovery

Partitioning

Snapshot Isolation

Online Operations

Database Snapshots

Checksum on Data Pages

Instant File Initialization

Checksum on Backups

Piecemeal Restore

Page-level Restore

Dedicated Administrator Connection

CPU Affinity

AWE Memory

Attach/Detach

Backup Media Mirroring

Integration Services

Merging Data from Heterogeneous Data Stores

Pipeline Improvements

Populating Data Warehouses and Data Marts

Persistent Lookups

Cleaning and Standardizing Data

Lookup Caching

Building Business Intelligence into a Data Transformation Process

Performance Counters Import

Automating Administrative Functions and Data Loading

Extensible, open APIs for integration with third party applications

Manageability

Management Studio

Policy Based Management (PBM)

Dynamic Management Views

Streamlined Installation

SQL Server Agent

Data Collector

SQL Management Objects

Server Group Management

Table and Index Partitioning

Multi-Server Query and Management

SQL Server Profiler

Database Engine Tuning Advisor

MOM Management Pack

Best Practice Analyzer

SQL Server Configuration Manager

Copy Database Wizard

Management Studio Standard Reports

Management Studio Custom Reports

MSX/TSX

Surface Area Configuration

Upgrade Advisor

Database Maintenance Plan

Database Mail

Security configuration Manager

Usage and Error Reporting

Replication Monitor

SQLCMD

Programmability

Common Language Runtime (CLR)

Language Integrated Query (LINQ)

XML and Web Services

ADO.Net Object Services

Enhanced Query and Data Access

DATE/TIME

Integrated VS Tools

HIERARCHY ID

Service Broker

FILESTREAM Data

Connectivity: ADO.NET

Integrated Full Text Search

Connectivity: JDBC

Sparse Columns

Connectivity: OLE DB

Large User Defined Types

Connectivity: ODBC

Spatial Data Types and Virtual Earth Integration

Technologies: LINQ

SMO, AMO, NMO, RMO

Reporting Services

Enterprise Managed Reporting Environment

Enterprise Reporting Engine

Report Designer

Microsoft Office Integration

Report Manager

Manage Reporting Infrastructure

Model Designer

Report Builder Enhancements - New V2 version

Report Builder

Built-in Forms Authentication

BI development Studio

IIS Agnostic Report Deployment

Report Authoting

Word Rendering and Improved Excel Rendering

Report Management

Tablix Style Reports

Report Delivery

Managed Reporting

Ad-hoc Reporting

Data Integration (SAP DW/Essbase/Oracle)

Report Controls

UDM support

Scalability + Performance

Snapshot Isolation

Resource Governor

Scalable Shared Database (DSS)

Predictable Query Performance

Query Notifications / CacheSync

Data Compression and Backup compression

Partitioning

Hot Add CPU

Extended Events

Security

Surface Area Reduction

Transparent Data Encryption

Off-By-Default

Extensible Key Management

Native Encryption

Auditing Framework

CLR Integration Security

Change Data Capture - Logging Infrastructure

Authentication

Fine-Grained Access Control

User and Schema Separation

Execution Context