What is partitioning in SQL Server and when should you use it?

Partitioning divides large tables into smaller manageable segments.

Table partitioning improves manageability and performance by splitting data based on a partition function and scheme. Queries can perform partition elimination, scanning only relevant partitions instead of the entire table.