07 March 2008 13:44
ssqa.net
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 |
Filed under: sql server, 2008, reporting services, blogs, new, technet, ssis, management studio, data warehousing, ssrs, features, documentation, analysis services, ssas, integration services
