[SQL Server Data Warehousing] How do delete a part data from partition

We want to delete data (switch partitions) older than 2006 from a partitioned table. There is 2003, 2004, 2005 data that we want to switch, this comes to about 1.5 Billion rows.

While working on switching partitions, found out that up until 20071229, all the data is in one partition,

select @partition.TF_TBL_Fact_Store_Satles_trans(20071229) is 1. and switching partition, will switchout data up until this point.  I need to retain 2006 and 2007 data.

What is the best approach to this?

2006 and 2007 data is about 1.05 billion rows and older than 2006 is about 1.4 billiion rows(need to get rid of this 1.4B data and keep 2006/7).

How best can I handle this situation? Any inputs is much appreciated.

Thanks,

Suresh.

---

Suresh Channamraju

.

social.technet.microsoft.com/Forums