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