Basically, our database is created based on primary filegroup alone.
Now, I have done partitioning for a large table which was approx 25 GB. The partitioning was done on secondary filegroups which has data files located at different drives for performance optimization. Now when I look into the database it looks like that the primary filegroup size have not been decreased.
FYI, I have partitioned an existing table based on index.
It looks like that the data has been copied records from my primary filegroup to secondary filegroups instead of moving the records.
Is there any fix for this or does the partition increases the database size ?
The table size looks to be doubled in size after partition and is that going to enhance performance occupying a lot of memory ?
Can I remove the duplicating records from primary filegroups after it has been moved to secondary filegroups ?