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 strategydescribe the storage modes used for partitions, including MOLOP, ROLOP, HOLAPdescribe proactive caching for partitionscreate a local partition by filtering a fact tablecreate a local partition using a table, view or named querysetup 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 partitionenable write-back on a partition in Cube Designer and SQL Server Management Studio (SSMS)browse, delete, disable, and convert write-back datadesign aggregations for a partition using the Aggregation Design Wizardedit and delete partitions in a multidimensional modelmerge 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
-
5m 24sUpon completion of this video, you will be able to describe proactive caching for partitions. FREE ACCESS
-
6m 26sIn this video, find out how to create a local partition by filtering a fact table. FREE ACCESS
-
6m 17sIn this video, you will learn how to create a local partition using a table, view, or named query. FREE ACCESS
-
9m 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
-
4m 3sIn this video, find out how to create a partition on a remote computer. FREE ACCESS
-
4m 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
-
5m 34sIn this video, find out how to browse, delete, disable, and convert write-back data. FREE ACCESS
-
8m 28sIn this video, you will learn how to design aggregations for a partition using the Aggregation Design Wizard. FREE ACCESS
-
4m 48sIn this video, you will edit and delete partitions in a multidimensional model. FREE ACCESS
-
7m 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.