Implementing Partitions

SQL Server 2014
  • 12 Videos | 1h 19m 4s
  • Earns a Badge
Likes 5 Likes 5
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

  • Playable
    1. 
    Designing a Partition Strategy
    5m 45s
    UP NEXT
  • Playable
    2. 
    Understanding the Storage Modes for Partitioning
    6m 54s
  • Locked
    3. 
    Understanding Proactive Caching for Partitions
    5m 24s
  • Locked
    4. 
    Creating a Local Partition By Filtering a Fact Table
    6m 26s
  • Locked
    5. 
    Creating a Local Partition Using Tables or Queries
    6m 17s
  • Locked
    6. 
    Setting up for Remote Partition Creation
    9m 53s
  • Locked
    7. 
    Creating Remote Partitions
    4m 3s
  • Locked
    8. 
    Enabling Write-Back in a Partition
    4m 20s
  • Locked
    9. 
    Browsing and Managing Write-Back Data in a Partition
    5m 34s
  • Locked
    10. 
    Designing Aggregations for a Partition Using the Wizard
    8m 28s
  • Locked
    11. 
    Editing and Deleting Partitions
    4m 48s
  • Locked
    12. 
    Merging Partitions
    7m 13s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 9 Likes 9  
Likes 7 Likes 7