April 2, 2010 at 6:35 pm
Hi, We have a environment where we are planning to have 12 months of data. We are planning on implementing a sliding window scenario where we will delete data older than 12 months from all tables. We have about 20 tables that have a date column.
My initial thought was to create a partitioning Function based on the Date column, we will create a clustered index on that column. Can all tables (20 of them) share the same partitioning function and partition scheme?.
Any information is appreciated.
Thank You
April 3, 2010 at 7:18 am
jayanth-463157 (4/2/2010)
Can all tables (20 of them) share the same partitioning function and partition scheme?
The simple answer is yes, they can.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 3, 2010 at 12:20 pm
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply