Rules for Partitions

  • I have been reading every articule regarding partitioning and I havent seen anything about create filegroups, files, partition function for "future storage".

    I mean. I would like to know if I can create filegroups, files and partition function from now to 6 months in advance. So the data will storage in the proper filegroup.

    Is this posible and good for SQL ? so i dont have to split/merge every month

  • nothing?

  • I havent seen anything about create filegroups, files, partition function for "future storage".

    I mean. I would like to know if I can create filegroups, files and partition function from now to 6 months in advance.

    Is this posible and good for SQL ? so i dont have to split/merge every month

    What do you mean by Future storage? Does it mean the Storing the Data which is expected to be added in the future?

    You can create Filegroups, Files and Partition functions in advance.

    Give some more input to understand better.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Yes, I meant the Storing the Data which is expected to be added in the future.

    I just worked on that and it looks fine.

    Thank you so much!

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

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