Post reply

Pertition schema e function add new filegroup

  • January 17, 2008 at 1:30 am

    #91634

    Hi everyone,

    have successfully managed to create filegroup Function and partitioning scheme.

    My question is how then Next month incoming I increaze 2 functions. Next will be 200812...how I made addd to the logic?

    I found an example that explained ... but with a fixed number of

    Filegroup, making the switch IN / OUT. My case necessarily

    Thanks,

    Alen Italy

    PARTITION CREATE FUNCTION [] (DateCreazioneLogIIS datetime) AS

    RANGE LEFT FOR VALUES (

    DATEADD (ms, -3,'20070901 ')

    DATEADD (ms, -3,'20071001 ')

    DATEADD (ms, -3,'20071101 ')

    )

    CREATE PARTITION SCHEME [RaggruppamentiDateLog]

    AS PARTITION [DateCreazioneLogIIS] TO (

    [200709]

    [200710]

    [200711]

    [PRIMARY]

    )

  • March 17, 2008 at 8:58 am

    #790400

    I apolgise for just pasting a link, but I don't think we can answer your question in a simple post and Kimberley's white paper has to be one of the definitive sources for partitioned tables

    http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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