Consutar particiones
SELECT
t.name AS [Table],
i.name AS [Index],
p.partition_number,
p.rows,
f.name,
r.boundary_id,
r.value AS [Boundary Value]
FROM sys.tables AS t
JOIN sys.indexes AS i
ON t.object_id = i.object_id
JOIN sys.partitions AS p
ON i.object_id = p.object_id AND i.index_id = p.index_id
JOIN sys.partition_schemes AS s
ON i.data_space_id = s.data_space_id
JOIN sys.partition_functions AS f
ON s.function_id = f.function_id
LEFT JOIN sys.partition_range_values AS r
ON f.function_id = r.function_id and r.boundary_id = p.partition_number
WHERE i.type <= 1 AND t.name = @TABLA
ORDER BY p.partition_number ASC;
Eliminar Particion
ALTER PARTITION FUNCTION PARTCOL_function ()
MERGE RANGE (2365309);
Agregar Particion
ALTER PARTITION SCHEME PARTCOL_scheme
NEXT USED [PRIMARY]
ALTER PARTITION FUNCTION PARTCOL_function ()
SPLIT RANGE (2365309);
Mover partición a otra tabla
ALTER TABLE TABLA_PART1 SWITCH PARTITION 1 TO [TABLA_Stagin]
