What is Partitioning in SQL Server?

Partitioning divides large tables or indexes into manageable segments based on a partitioning key. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.