Data Warehouse scalability of SQL Server 2008 new features (i)

1. Introduction

Microsoft SQL Server 2008 provides a comprehensive data warehouse platform. It allows you to build and manage your data warehouse using a separate, integrated suite of products, and allows you to provide insights to your users. It can meet the needs of the largest enterprise and give your end users and it employees the rights they need.

The first thing to focus on deploying in SQL Server 2008 is to improve the scalability of the entire product suite to fully meet the needs of large enterprises. Here, we'll describe the features and improvements that we've added to improve your data warehousing experience. Establishment, management, transmission. SQL Server 2008 makes it easy for you to do all of this.

2. New Data Warehouse features illustrated

The table below shows the new scalability features in SQL Server 2008 and how they can help in the Data Warehouse (DW).

	Establish	Management	Provide insight information
SQL Server relational database management system	Merge statement change data capture (CDC) minimum log insert	Backup compression	Star Association performance faster parallel query on partitioned tables grouping SETS
Resource Monitor
Data compression alignment partitioned indexed view
Integration Services	Lookup Performance Pipeline Performance
Analysis Services		Backup	MDX query performance: Block compute query and write back performance
Extensible shared Database
Reporting Services		Report Scalability Server Scalability

Figure 1: Star Association query plan, associated with reduced effective data warehouse processing

This article briefly describes the improvements to the data warehouse in each of the different components of SQL Server 2008, and how they can help you get the most out of your Data warehouse.

The improvement of data warehouse of 3.SQL server relational database management system

The SQL Server 2008 relational database management system is much better than previous versions, so it performs better when you create, manage, and query large data warehouses. This section will detail the improvement of the relational database management system Data Warehouse as listed in table 1.