Advertisement
Promo

Databases Toolkit

Download now

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

PublisherMicrosoft
Format WORDDate added23 Feb 2007
Topics Data Acquisition - ETL, Database Management, Business Intelligence - Data Warehousing
Downloads145

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.

Download now

Did you find this white paper useful?
30 out of 50 users found this white paper useful


  • Trackback
  • Clip Link

Related white papers

Customer Centricity, Master Data and the "360-Degree View"

When reviewing the popular literature on customer data integration and master data management, a frequently recurring business driver is the ability to establish a "360-degree view of the customer." This...


Gaining Perspective on Performance: Best Practices for an Effective 360-Degree Feedback Program

When planned in advance and run strategically, a 360-degree feedback program can offer serious business value. Feedback from multiple raters provides useful data on your employees, their performance, and their...


Predictive Analytics for the Claim Handling Process

Predictive Analytics for the Claim Handling Process: Understanding the Analytics Behind Predictive Claims This 12-page technical brief serves as a guide for understanding how Predictive Claims' predictive modeling capabilities can...


Wireless Clinical Trial of Data Capture Using a Personal Digital Assistant

Personal Digital Assistants (PDAs) have the potential to improve clinical trial data collection; however, most current PDA-based clinical data collection systems typically collect and store data in the offline mode,...


Premier Research Group Limited Supports Clinical Trials With Consolidated, Less Costly IT System

Premier Research Group Limited wanted to leverage technology to be more responsive to clients, ultimately helping clients improve their clinical trials and increasing client satisfaction and consolidate numerous geographically-dispersed clinical...


Windows 7 Adoption Survey: A Survey of Technology Professionals

This Dimensional Research report is based on a survey of 1,142 IT professionals. The goal of the survey was to gather data about current plans and attitudes within corporate IT...


Incorporating Site-Level Knowledge to Extract Structured Data From Web Forums

Web forums have become an important data resource for many web applications, but extracting structured data from unstructured web forum pages is still a challenging task due to both complex...


Broadband Deals? Powered by Top 10 Broadband

150+ broadband packages

Compare 30+ mobile broadband deals

Mobile Broadband »
White Paper

Featured White Paper

IBM Virtualization Services

Virtualization is a powerful technology and can have profound effects on the datacenter; however, it should be viewed as a component of an overall IT strategy that will be able to support the enterprise's needs. IDC recommends that enterprises look at the entire architecture and determine how to best deploy virtualization

Download Now

Other White Papers

HP print solutions and 3M

the objective for 3M was to optimize office printing infrastructure at 3M locations worldwide...

IBM XIV® Storage System: Thin Provisioning Reinvented

Managing IT storage infrastructure is an endless balancing act of providing enterprise-class...

See All White Papers


Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters