摘要：ADO Multidimensional Now that you've taken a whirlwind tour of MDX, let's shift gears and look at another enabling technology: ADOMD. ADOMD allows you to query both the cube schema and data from a si... 阅读全文

摘要：This is avery short post containing a useful code snippet for writing to a SQL Server Integration Services (SSIS) variable from within a script task. Imports Microsoft.SqlServer.Dts.Runtime Public... 阅读全文

摘要：Data Warehouse Design Considerations Dave Browning and Joy Mundy Microsoft Corporation December 2001 Applies to: Microsoft® SQL Server™ 2000 Summary: Data warehousing is one of the more powe... 阅读全文

摘要：Transforming OLTP Data to OLAP Data Warehouses The transformation of OLTP data so that it gives acceptable performance in an OLAP system requires these processes: Merge Data You must be able to mer... 阅读全文

摘要：Using Partitions in a Microsoft SQL Server 2000 Data Warehouse Author: Joy Mundy Contributors: Stuart Ozer, Lubor Kollar, Len Wyatt Microsoft Corporation February 2001 Summary: This article describ... 阅读全文

摘要：The Microsoft Data Warehousing Strategy A Platform for Improved Decision-Making through Easier Data Access and Analysis July 11, 1998 Microsoft Corporation Contents Introduction The Data Warehous... 阅读全文