Table with 120 Million rows in SQL2005. This table grows around 400, 000 rows everyday. Insertion is made by a package every morning. In order to improve performance in the insertion into the table, I’m planning to do a partition. Table has clustered index (id, date).

-- partition schemeCREATE PARTITION SCHEME schemeAS PARTITION functionALL TO (week1, week2.....) -- file groups will be located in different drives

-- move existing table/data to new partitionALTER TABLE [table] DROP CONSTRAINT PK_constraint WITH (MOVE TO [scheme] (Date)) note: how I move the data to the exact week ????? am I using the correct syntax?

J Hines (8/25/2011)This is EXACTLY what I am trying to do, only by month rather than week. Did you ever get help with this?

1) Please don't post a "me too" to a 2 year old thread - start a new one.

2) Partitioning is a VERY advanced topic where you can get yourself into trouble (and even make things much worse) if you don't know what you are doing. PLEASE do yourself a favor and get some professional help for a little bit to make sure you know what you really need to do and how to properly implement/test/maintain it.