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.