Move all (or chosen) standard indexes from your primary file group to a secondary file group (hopefully located on a seperate array)
excludes clustered indexes, statistics and indexes associated with a primary key
when you run it - set the debug to 1 to identify what the script will move, set it to 0 to actually perform the move.
the @rowcnt parameter will also allow you to specify the max number of rows in the index to move - I tried moving an index from a V V V large table (240Gb) and it took 2 hours.
Stored Proc to List Columns for a Primary Key
Stored procedure to return the list of columns of the primary key for a table. The name of the column for the result set is the name of the primary key for the table.
2006-09-14 (first published: 2006-09-07)