The main disadvantages of MS SQL table partitions are the object maintenance to keep the partition definitions up to date with the partitioning column.