Oleg Netchaev (11/11/2010)

---

A little ambiguity around Partitions can be on any column part aside, this was a very good question, thank you Stewart. Interestingly, we had a question on ASK side asking about guidelines and considerations for deleting in excess of a billion records from existing table, and the answer by Scot Hauder suggested using switch, and included a thoroughly commented sample. I am not sure wherer OP opted to use Scot's solution or not, but the answer clearly demonstrated a practical application of the technique in real life scenario, saving someone from quite a lot of hustle.

Oleg