Case Studies: Manufacturing

Industries: Financial Services | Manufacturing | Retail | Professional Services | Government

See how companies are using SQL Server to run their most demanding applications, make better decisions, and get faster results.
Read more SQL Server 2005 case studies. Or, search the Microsoft Case Studies site to find examples that are relevant to your business.

Server Consolidation

SQL Server 2005 Enhances Performance of Data Warehouse for Microsoft IT Tax Group

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 the beta edition of 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. The company also reduced migration time by half, and enjoyed a 25 percent server consolidation.