How can I expand the size of a partition for a partitioned table that has filled up?
A partitioned table can use any space on the segment to which it is assigned. If you need more space, extend the partition. For example, suppose you have a table that is assigned to seg1, which has three fragments on three devices. If you partition this table three ways, each partition will be assigned to a different fragment (or device in this case). If one partition uses all the space on its fragment, it will begin to allocate space on another fragment. So you don’t run out of space for any partition until you run out of space for all partitions. To increase space, alter the database and extend seg1 there. SQL Server assigns different partitions to different fragments in order to spread I/O. If you find that a partition has filled its fragment and you are worried about performance hits due to spreading I/O, try bulk copying out all the data and rebuilding the table. Aside from I/O considerations, you still get substantial benefits out of partitioning because of the reduction in locki
