October 12, 2008 at 8:15 am
Can some one please provide me the script to move non-clustered indexes from secondary file to primary file. I moved the indexes to secondary file by creating the filegroup, now I want to use the reverse engineering method to move these indexes back to primary file with clustered data. Please help.
October 12, 2008 at 8:58 am
Drop them and rebuild them on the primary filegroup. ALTER INDEX and CREATE INDEX have options for specifying the filegroup.
October 12, 2008 at 12:54 pm
Can you please send the scripts? Thanks
October 12, 2008 at 1:09 pm
DROP INDEX dbo.TableName.IxName
CREATE NONCLUSTERED INDEX IxName ON dbo.TableName (Columns, Names) ON [PRIMARY]
Please keep in mind that Primary is a reserved keyword so you have to use the brackets around it!
October 12, 2008 at 7:24 pm
Read books online for the parameters for the create index command. You might want to note the fillfactor before you do this.
October 12, 2008 at 7:25 pm
And be sure you know what columns are in the index before you drop it.
October 13, 2008 at 7:24 am
I need to rebuild the indexes on database level for nonclustered indexes in order to move them to primary file.
October 13, 2008 at 9:11 am
We understood you the first time.
Where are you blocking at?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply