Post reply

Dynamic Partitioning

  • May 18, 2007 at 9:09 am

    #120147

    Hi,

    is it possible to set up a dynamic partition on a table such that only data for the current year is kept in one filegroup and everything else is kept in another? For example if I set the partition like this:

    CREATE PARTITION FUNCTION [Data Partition Range](datetime)

    AS RANGE LEFT FOR VALUES (year(getdate()) - 1)

    I'm sure the syntax is completely wrong, but it should give you an idea of what I want to do.

    Thanks for any help!

    Frank

  • May 18, 2007 at 2:49 pm

    #707590

    you can simply set the partitions "ahead-of-time" and they will only be populated when the data gets there. So you could plan for say 7 years and let the ball roll


    * Noel

  • May 19, 2007 at 12:08 pm

    #707646

    Check the following Technical Articles from Kimberly...

    Microsoft SQL Server 9.0 Technical Articles
    Partitioned Tables and Indexes in SQL Server 2005

    http://msdn2.microsoft.com/en-us/library/ms345146.aspx

     

    MohammedU
    Microsoft SQL Server MVP

  • May 21, 2007 at 6:05 am

    #707781

    Thanks Noel and MohammedU

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

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