Table partitioning isn’t a silver bullet for large tables. Used well, it improves data management and maintenance; used poorly, it leads to unpredictable performance and difficult troubleshooting.

In this two-part, demo-driven deep dive, we build a clear understanding of how table partitioning works in SQL Server and how design and operational choices affect performance. The sessions move from partitioning mechanics and elimination to real-world design, indexing, and troubleshooting, giving attendees a practical mental model they can apply confidently in production.

Part 1 focuses on the mechanics of table partitioning and how SQL Server actually uses partitions. We start with partition functions and schemes, how boundary values are interpreted, and how rows are positioned across partitions—foundations that are critical for designing partitioning correctly.

Through practical demos, we explore core partition operations such as switching data in and out, splitting and merging partitions, and the mechanical constraints these operations introduce. With this foundation in place, we move into partition elimination: what enables it, what breaks it, and how to recognize effective pruning by reading execution plans.