Problems when devices for partitioned tables are full

Simply adding disks and re-creating indexes when partitions are full may not solve load-balancing problems. If a physical device that underlies a partition becomes completely full, the data-copy stage of re-creating an index cannot copy data to that physical device.

If a physical device is almost completely full, re-creating the clustered index does not always succeed in establishing a good load balance.