Table Partitioning 101

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.

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