Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

Data Warehouse Scalability Features in SQL Server 2008 - SQL Server Knowledge Sharing Network (@sqlmaster)

Data Warehouse Scalability Features in SQL Server 2008

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform.

Though there isn't a real-time data warehouse implementation within my work place, I have browsing through the Technet documentation & BOL (SQL2008) about specific enhancements within Data Warehousing technologies, it means they are very useful for large organisations having range of desktop tools such as Word, Excel & Reporting based tools. The new version will enable you to build your data warehouse, and query and analyze its data, all these are built-in within the SQL Server relational database system, along with flavour of tools such as Analysis Services, Integration Services, and Reporting Services.

So if you want to know about new performance manageability features for Data Warehousing among all of these components, download this document. For instance the following table shows what it means:

 

 

Build

Manage

Deliver Insight

SQL Server Relational DBMS

MERGE statement

Change data capture (CDC)

Minimally logged INSERT

Backup compression

Star join performance

Faster parallel query on partitioned tables

GROUPING SETS

Resource governor

Data compression

Partition-aligned indexed views

Integration Services

Lookup performance

Pipeline performance

 

 

Analysis Services

 

Backup

MDX Query Performance: Block Computation

Query and Writeback Performance

Scalable Shared Database

Reporting Services

 

Reporting scalability

Server scalability

 

Comments

# http://sqlservercode.blogspot.com/2008/03/links-of-week-20080309.html

Monday, March 10, 2008 9:38 AM by TrackBack