What is SQL Server partitioning and how does partition elimination work?

Partitioning splits a table into manageable segments while partition elimination skips irrelevant partitions.

SQL Server partitioning divides large tables into partitions based on a partition function. The optimizer can eliminate partitions during query execution if predicates align with partition keys, reducing IO significantly.