SQL server 2005 partitioning

  • I'm having to move 7 million rows from one table to another. If I use delete, log gets filled up pretty quickly. I could delete them in batches of 1000, but it could take significantly longer since my windows of moving data is about 15 mins. Is table partitioning my option?

    There is DueDate and DocumentStatus on this table. Can I have partition on both the columns? Because I only want to move all the records where DocumentStatus = 'CLOSED' and DueDate < DATEADD(YEAR,-1,GETDATE())

    If two columns are not allowed on partition, what is my workaround?

    Please advise. Also, once I move the data, can I drop the partion and file groups that gets created? Coz, partition might have slow impact on the query as most of the queries used do not base on the partion columns.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply