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
-
1.Designing a Partition Strategy5m 45sUP NEXT
-
2.Understanding the Storage Modes for Partitioning6m 54s
-
3.Understanding Proactive Caching for Partitions5m 24s
-
4.Creating a Local Partition By Filtering a Fact Table6m 26s
-
5.Creating a Local Partition Using Tables or Queries6m 17s
-
6.Setting up for Remote Partition Creation9m 53s
-
7.Creating Remote Partitions4m 3s
-
8.Enabling Write-Back in a Partition4m 20s
-
9.Browsing and Managing Write-Back Data in a Partition5m 34s
-
10.Designing Aggregations for a Partition Using the Wizard8m 28s
-
11.Editing and Deleting Partitions4m 48s
-
12.Merging Partitions7m 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.