Loading Data In Real Time
After an overview of partitioning and how to set up partition functions & schemes we'll take a look at how to load data and instantly switch it into production without significant impact to your database availability.
Partition Functions & Schemes
Creating partitioned tables
The $partition function
and system tables for viewing partition information