Introduction to SQL Server 2008 Data Warehouse scalability-related features

SQL Server Technical Documentation

Author: Eric N. Hanson, Kevin Farlee, Stefano Stefani, Shu Scott, Gopal Ashok, Torsten grabs, Sara Tahir, Sunil Agarwal, T.K. Anand, Richard Tkachuk, Catherine Chang, and Edward melomed, Microsoft Corp.

Technical Inspector: Eric N. Hanson, Microsoft Corp. release date: December 2007

Applicable products: SQL Server 2008

Summary: SQL Server 2008 has made a huge leap in the scalability of the data Warehouse, and no product has ever been able to meet the needs of large enterprises for data warehouses as easily as SQL Server2008. SQL Server2008 integrates a range of products to help you build a data warehouse and query and analyze its data. This includes SQL Server's relational database system, Analysis Services, Integration Services, and Reporting Services. This document will introduce the high performance and new management capabilities of these components, both of which can improve the scalability of the Data warehouse.

Directory

SQL Server 2008 Data Warehouse Scalability Related features introduction 1

Catalog 3

Introduction 1

Data Warehouse new Features 1

SQL Server relational database management system for Data Warehouse Improvement 1

Star Association 2

Partitioned Table Parallel 3

aligning partitioned Indexed views 4

GROUPING SETS4

MERGE5

Change data Capture 6

Minimum log record INSERT7

Data compression 8

Backup Compression 8

Resource Governor8

Improved Integration Services 10

Lookup Performance 10

Pipe Performance 11

Analysis Service Improvements 12

MDX query performance: Block calculation 12

Query and write-back performance 14

Analysis Service enhancements for backup 14

Extensible shared data for profiling services 15

The improvement of report service 16

Report Scalability 16

Server Scalability 16

Summary 16

Ref. 17