question

wemorganjr avatar image
wemorganjr asked

PARTITION SCHEME values are out of order

i added a new year to a Partition Function and it completed successfully. --ALTER DATABASE dbname ADD FILEGROUP fgname_2018 --ALTER DATABASE dbname ADD FILE filename_2018 --ALTER PARTITION SCHEME DATESKEY_SCHEME NEXT USED RWSBILO_2018; --ALTER PARTITION FUNCTION dateskey () SPLIT RANGE (20171231) -- New Range Command(s) completed successfully. When I script both the partition scheme the values are out of order 1) does it matter? if so what do i need to do? CREATE PARTITION SCHEME [DATESKEY_SCHEME] AS PARTITION [DATESKEY] TO ([2013], [2014], [2015], [2016], [2018], [2017])
partitioningpartition
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.