Here is another popular lab from Hands-On-Lab library: Partitioning in SQL Server.
Partitioning is the database process where large tables are divided into multiple smaller partitions. The main objective of the partitioning is to aid in the maintenance of huge tables and to reduce the overall response time to load bulk data into tables. Partitioning a table helps improving read query performance, however not all read queries may are optimized. This lab is divided into three exercises. In the first exercise, we will learn about creating partition. In the second exercise we will learn about managing partitions and in the third exercise, we’ll talk about scenarios where partitioning is helpful in optimizing read queries.
Exercise 1: Creating Partition
Exercise 2: Optimizing query performance using partitioning
Exercise 3: Managing Partitions
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.