I have a db with a 280GB data file. It has a table with 185GB. I want to create a 2nd data file and put that table into it.
creating the 2nd data file seems straight forward. I have not been able to find the best way to move the table into the 2nd data file. Does the 2nd data file need to be in a 2ndary filegroup, or can they both be in the primary file group. I do not find anything in the table properties that tells which data file it is in, only which file group it is in.
Your help is greatly appreciated.
P.S. - this is a MOSS (SharePoint) database, so I can not go in and create (or re-create) a clustered index on the table.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.