In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.
Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.
This article gives an example of loading partitioned tables incrementally using SSIS
Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
Enterprise Edition customers enjoy the manageability and performance benefits offered by table partitioning, but this feature is not available in Standard Edition. Aaron Bertrand explains his idea for achieving at least some of partitioning's upsides on any edition.
A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.