Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Table Partitioning 101

PASS Data Community Summit via YouTube

Overview

Learn the fundamentals of Table Partitioning in SQL Server, available in all editions since SQL 2016/SP1. Explore the advantages and disadvantages of this feature, understanding its role in performance improvement and administrative ease. Dive into key concepts including partition elimination, administration, potential issues, primary keys, file groups, partition schemes, and functions. Discover the differences between Range Left and Range Right, the importance of data types, and techniques like Switch Out and Truncate. Examine unsupported features, data growth strategies, and data movement processes. Gain practical insights through a partition test database in this comprehensive entry-level session.

Syllabus

Introduction
Disclaimer
Who am I
Agenda
Table Partitioning
Partition Elimination
Partition Administration
Potential Issues
Primary Key
File Groups
Partition Scheme
Partition Function
Range Left vs Range Right
Data Types Matter
Partition Schemes
Switch Switch
Switch Out
Truncate
Unsupported Features
Data Growth
Data Movement
Merge
Partition Test Database

Taught by

PASS Data Community Summit

Reviews

Start your review of Table Partitioning 101

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.