White Papers White Papers
SQL Server 2005 Enhances Performance of Data Warehouse for Microsoft IT Tax Group
Overview Microsoft Corporation, the world's largest software development company, has annual revenues exceeding U.S.$34 billion and operations in 89 countries. As with other global companies, Microsoft has lots of taxes to track and pay - on the local, regional, national, and international levels. The Microsoft IT Tax and Audit Product Group created a 1.8 terabyte Tax Data Warehouse to keep track of financial information. To enhance performance, the company upgraded its Tax Data Warehouse to Microsoft SQL Server 2005 from SQL Server 2000. Since the upgrade, the company has seen a 75 percent reduction in the time required to process OnLine Analytical Processing (OLAP) cubes; 50 percent faster Extract, Transform, and Load (ETL) data processing time; and enhanced developer productivity.
| Publisher | Microsoft | File Format | WORD |
|---|---|---|---|
| Date Published | February 2007 | ||
| Format | Case Studies | ||
| Topics |
|
||



