hi ,
i have tables and indexes on primary group,i want to move them to secondary filegroup. Can anyone tell me the easiest way to do. I know creating a cluster index on each table moves the table to where the index is specified. I want to know if there is a work around to move all tables and indexes in a single go to a differnt filegroup.. thanks in advance.