Implementing Partitions
SQL Server 2014
| Intermediate
- 12 videos | 1h 15m 4s
- Earns a Badge
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 45sUpon 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 54sAfter completing this video, you will be able to describe the storage modes used for partitions, including MOLOP, ROLOP, and HOLAP. FREE ACCESS
-
3. Understanding Proactive Caching for Partitions5m 24sUpon completion of this video, you will be able to describe proactive caching for partitions. FREE ACCESS
-
4. Creating a Local Partition By Filtering a Fact Table6m 26sIn this video, find out how to create a local partition by filtering a fact table. FREE ACCESS
-
5. Creating a Local Partition Using Tables or Queries6m 17sIn this video, you will learn how to create a local partition using a table, view, or named query. FREE ACCESS
-
6. Setting up for Remote Partition Creation9m 53sFind 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
-
7. Creating Remote Partitions4m 3sIn this video, find out how to create a partition on a remote computer. FREE ACCESS
-
8. Enabling Write-Back in a Partition4m 20sIn this video, you will learn how to enable write-back on a partition in Cube Designer and SQL Server Management Studio (SSMS). FREE ACCESS
-
9. Browsing and Managing Write-Back Data in a Partition5m 34sIn this video, find out how to browse, delete, disable, and convert write-back data. FREE ACCESS
-
10. Designing Aggregations for a Partition Using the Wizard8m 28sIn this video, you will learn how to design aggregations for a partition using the Aggregation Design Wizard. FREE ACCESS
-
11. Editing and Deleting Partitions4m 48sIn this video, you will edit and delete partitions in a multidimensional model. FREE ACCESS
-
12. Merging Partitions7m 13sFind 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.
