SQL Server Performance
  1. Ruksharr New Member

    Can anybody show that how can we create table on a secondary file group and move it to primary ?
  2. Luis Martin Moderator

    To create you have to use ON option in CREATE TABLE. Of course you have to create secondary file group first.
    For the second part, severals options.
    For instance, if the table have cluster index, just move cluster to primary. Or script the table and modify to primary.
    Now,why you just create in primary in first place?

Share This Page