Measure tables per filegroup from allocation metadata, include LOB and overflow pages, and separate partition placement from growth history.
Rebuilding One Partition Online Instead of the Whole Index
A big partitioned table does not need a full index rebuild every night. Here is how to rebuild one partition safely.
Table Partitioning Is Not Sharding: What Partitioning Really Gives You
See why partitioning is not sharding, build monthly partitions, inspect elimination, and switch a month out for simpler data management.
Adding IDENTITY to an Existing Column With ALTER TABLE SWITCH
Add IDENTITY to an existing column with an empty matching table, ALTER TABLE SWITCH, a reseed, and full dependency checks.
Sharding: When One Server Is Not Enough
Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.
Loading Partitions in Parallel
Loading partitions in parallel uses separate staging tables, controlled workers, and partition switching to publish data without chaotic locks.
Numbers Table vs GENERATE_SERIES: Building Rows on Demand
Learn numbers table in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.