How about the case when new data starts to fill your topmost partition? How do you avoid unnecessary data movement?

When I implemented partitioning I had 2 topmost partitions and a SQL Agent Job running a SSIS package to react on the fullness of the second topmost partition. If it were getting full then we split the topmost partition. Only to avoid any kind of data movement.

/Johan Klövstedt