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.

Further White Paper Details
PublisherMicrosoft File FormatWORD
Date PublishedFebruary 2007
FormatCase Studies   
Topics
    N/A
  • Featured White Papers
Thin clients switch on digitally excluded

Thin clients switch on digitally excluded

Case study: Digital inclusion project tackles social exclusion in Liverpool more

Renault goes multilingual

Renault goes multilingual

Case study: Translation tech turns docs into 23 languages… more


Quick Sitemap Links: