SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.

An ISV recently found an anomoly in their implementation of a “drop table partition” function which could lead to unexpected partitions being switched out. Typically, to do this “drop partition logic” SQL Server partitions are manipulated using the following operations: ·      switch-out the partition which isn’t needed anymore (or being archived) into an empty target…

2