Post reply

Adding ranges to an existing partion function

  • January 2, 2020 at 4:35 am

    #3711672

    I currently have the below code for partition scheme and function. Is the ALTER PARTITION SPLIT Range the best way to add additional ranges to the function?

    CREATE PARTITION SCHEME [ps_My_Rent] AS PARTITION [pfn_My_Rent] TO ([DB_DPARTITIONS_2012], [DB_DPARTITIONS_2013], [DB_DPARTITIONS_2014], [DB_DPARTITIONS_2015], [DB_DPARTITIONS_2016], [DB_DPARTITIONS_2017], [DB_DPARTITIONS_2018], [DB_DPARTITIONS_2019])
    GO 
    CREATE PARTITION FUNCTION [pfn_My_Rent](DATETIME) AS RANGE LEFT FOR VALUES (N'2012-01-01T00:00:00.000', N'2013-01-01T00:00:00.000', N'2014-01-01T00:00:00.000', N'2015-01-01T00:00:00.000', N'2016-01-01T00:00:00.000', N'2017-01-01T00:00:00.000', N'2018-01-01T00:00:00.000', N'2019-01-01T00:00:00.000')
    GO

  • January 3, 2020 at 5:10 am

    #3712031

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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