Servers

    Project REAL: Data Lifecycle Partitioning

    Language:
    English
    This paper provides a detailed discussion on how partitioning was implemented, both on the relational data warehouse and in the Analysis Services cubes.
    • Version:

      1.0

      File Name:

      Project REAL Data Lifecycle Partitioning.doc

      Date Published:

      8/19/2005

      File Size:

      260 KB

        This paper provides a detailed discussion on how partitioning was implemented, both on the relational data warehouse and in the Analysis Services cubes. In addition to providing the general "how we did it" overview, we include specific code segments and lessons learned in the hopes that the reader will benefit from both our successes and failures. It is our hope that anyone planning or implementing a BI system based on SQL Server 2005 will find the reference implementation useful.
    • Supported Operating System

      Windows XP Service Pack 2

        The file is a Microsoft Word document. Users who do not have Microsoft Word can view this document through the downloadable Word Viewer.

        1. Click the Download button on this page to start the download.

        2. Do one of the following:

          • To start the installation immediately, click Open or Run this program from its current location.

          • To copy the download to your computer for installation at a later time, click Save or Save this program to disk.



    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 04

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 05

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial