Post reply

Partitioning Question;

  • April 2, 2010 at 6:35 pm

    #233260

    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

    #1145310

    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
    All articles available on SQL.kiwi
    @SQL_Kiwi

  • April 3, 2010 at 12:20 pm

    #1145367

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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