Tag Info

New answers tagged

1

From SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 there is support for 15,000 partitions so to be honest, you don't really need to do that much dynamically. Instead of having a complex daily process (Dynamically add filegroup and boundaries) with an opportunity to fail, simply create the partitions up-front from now to the year 2020, and you're well ...


1

To add a new partition, use SPLIT RANGE. Assuming you have the following partition: CREATE PARTITION FUNCTION pfTest(int) AS RANGE LEFT FOR VALUES (10, 20, 30); CREATE PARTITION SCHEME psTest AS PARTITION pfTest TO ([GRP1], [GRP2], [GRP3]); .. you can add a new partition by "splitting" the last range from (30 to infinity) to (30-39) and (40 to infinity). ...



Top 50 recent answers are included