August 6, 2008 at 1:29 pm
Hi I have a question/best practice regarding sql2005 and data partitioning.
A new product will be going out shortly where they will have a audit table that will receive roughly 1.1 million rows per day. They sent me a script to run daily which will purge all the data older then 7 days. ( 1.1 million rows)
I instantly thought I could probably take advantage of data partitioning but need some guidance on the best way to approach this.
Outside of labs I have never implemented this.
If anyone has a scenario like this I would like some input.
All audit data will be deleted based on a datetime field which will be getdate() on insert.
They need to save it for 7 day ??
Any suggestions would be helpful.
August 7, 2008 at 2:25 am
Hi check this example this will demonstrate how partition helps you to store the data efficiently. Hope this will help you.
http://sqlity.blogspot.com/2008/03/partition-table-example.html
Abhijit - http://abhijitmore.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply