Move #SQL Server #Tables to Different Filegroups
In this tip we look at different ways to move an existing table and data to a new filegroup.
For this, we need to to do the following:
Create a secondary filegroup.
Add data files to the secondary filegroup.
Move the table to the secondary filegroup by moving the clustered index with the primary key constraint.
Move the tables to the secondary filegroup by moving the clustered index without the primary key.
move data from one filegroup to another
sql server move filegroup to different drive
sql server move heap table to another filegroup
move partitioned table to another filegroup
sql server move lob data to another filegroup
sql server move file to different #filegroup
move primary key to different filegroup
move non clustered index to different filegroup