Particionar tabla SQL Server, y llenar automaticamente con registros
CREATE TABLE tablanormal
(
llave bigint primary key,
dato varchar(15)
);
CREATE TABLE tablaparticionada
(
llave bigint,
dato varchar(15)
);
Alter Database mibase
Add FileGroup [part_1_100000]
Alter Database mibase
Add FileGroup [part_100001_200000]
Alter Database mibase
Add FileGroup [part_200001_300000]
Alter Database mibase
Add FileGroup [part_300001_400000]
Alter Database mibase
Add FileGroup [part_400001_500000]
Alter Database mibase
Add FileGroup [part_500001_600000]
Alter Database mibase
Add FileGroup [part_600001_700000]
Alter Database mibase
Add FileGroup [part_700001_800000]
Alter Database mibase
Add FileGroup [part_800001_900000]
Alter Database mibase
Add FileGroup [part_900001_1000000]
Alter Database mibase
Add FileGroup [part_1000001_1500000]
Alter Database mibase
Add FileGroup [part_1500001_2000000]
Alter Database mibase
Add FileGroup [part_2000001_2500000]
Alter Database mibase
Add FileGroup [part_2500001_3000000]
Alter Database mibase
Add FileGroup [part_3000001_3500000]
Alter Database mibase
Add FileGroup [part_3500001_4000000]
Alter Database mibase
Add FileGroup [part_4000001_4500000]
Alter Database mibase
Add FileGroup [part_4500001_5000000]
Alter Database mibase
Add FileGroup [part_5000001_5500000]
—— >>>>>> Descargar Archivo
Leave a Reply