Effects of imbalance of data on segments and partitions

An imbalance of pages in partitions usually occurs when partitions have run out of space on the device, and extents have been allocated on another physical device. This is called extent stealing.

Extent stealing can take place when data is being inserted into the table with insert commands or bulk copy and while clustered indexes are being created.

The effects of an imbalance of pages in table partitions is: