Implementing Partitions

SQL Server 2014    |    Intermediate
  • 12 videos | 1h 15m 4s
  • Earns a Badge
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
In SQL Server Analysis Services (SSAS), partitions are used to provide the physical storage for the fact data in a measure group. Discover how to design, create, and work with both local and remote partitions.

WHAT YOU WILL LEARN

  • Describe partitions in a multidimensional model, including the types local and remote, aggregations, and design strategy
    Describe the storage modes used for partitions, including molop, rolop, holap
    Describe proactive caching for partitions
    Create a local partition by filtering a fact table
    Create a local partition using a table, view or named query
    Setup the configuration for remote partitions, including specifying valid server names, creating and deploying a secondary database, and enabling features in sql server management studio (ssms)
  • Create a remote partition
    Enable write-back on a partition in cube designer and  sql server management studio (ssms)
    Browse, delete, disable, and convert write-back data
    Design aggregations for a partition using the aggregation design wizard
    Edit and delete partitions in a multidimensional model
    Merge partitions in a multidimensional model

IN THIS COURSE

  • 5m 45s
    Upon completion of this video, you will be able to describe partitions in a multidimensional model, including the types Local and Remote, aggregations, and design strategy. FREE ACCESS
  • 6m 54s
    After completing this video, you will be able to describe the storage modes used for partitions, including MOLOP, ROLOP, and HOLAP. FREE ACCESS
  • Locked
    3.  Understanding Proactive Caching for Partitions
    5m 24s
    Upon completion of this video, you will be able to describe proactive caching for partitions. FREE ACCESS
  • Locked
    4.  Creating a Local Partition By Filtering a Fact Table
    6m 26s
    In this video, find out how to create a local partition by filtering a fact table. FREE ACCESS
  • Locked
    5.  Creating a Local Partition Using Tables or Queries
    6m 17s
    In this video, you will learn how to create a local partition using a table, view, or named query. FREE ACCESS
  • Locked
    6.  Setting up for Remote Partition Creation
    9m 53s
    Find out how to set up the configuration for remote partitions, including specifying valid server names, creating and deploying a secondary database, and enabling features in SQL Server Management Studio (SSMS). FREE ACCESS
  • Locked
    7.  Creating Remote Partitions
    4m 3s
    In this video, find out how to create a partition on a remote computer. FREE ACCESS
  • Locked
    8.  Enabling Write-Back in a Partition
    4m 20s
    In this video, you will learn how to enable write-back on a partition in Cube Designer and SQL Server Management Studio (SSMS). FREE ACCESS
  • Locked
    9.  Browsing and Managing Write-Back Data in a Partition
    5m 34s
    In this video, find out how to browse, delete, disable, and convert write-back data. FREE ACCESS
  • Locked
    10.  Designing Aggregations for a Partition Using the Wizard
    8m 28s
    In this video, you will learn how to design aggregations for a partition using the Aggregation Design Wizard. FREE ACCESS
  • Locked
    11.  Editing and Deleting Partitions
    4m 48s
    In this video, you will edit and delete partitions in a multidimensional model. FREE ACCESS
  • Locked
    12.  Merging Partitions
    7m 13s
    Find out how to merge partitions in a multidimensional model. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Book Data Analytics with SAS: Explore Your Data and Get Actionable Insights With the Power of SAS
Book Business Analytics with SAS Studio: Deliver Business Intelligence by Combining SQL Processing, Insightful Visualizations, and Various Data Mining Techniques , First Edition