Thank you very much guys- I really admired all of your comments and suggessions.

I ran the missing indexes script and I do not see any indexes are missing. what will be the problem you think?

Thank you somuch! I really appreciate your help.

I am not asking for the process. All I am asking is when you move the nonclustered indexes to other disk array do you need the schema change or for...

Try this

SELECT

CASE WHEN CITY LIKE 'B%' THEN CITY ELSE '' END as 'CITY1',

CASE WHEN CITY LIKE 'L%' THEN CITY ELSE '' END as 'CITY2',

CASE...

Shree,

You can use CASE command to display the rows into colums; for example;

CREATE TABLE [dbo].[fscity](

[state] [nchar](10) NULL,

[city] [nchar](10) NULL

) ON [PRIMARY]

I inserted couple of cities and used this command;

SELECT ...

Thanks for the quick reply. I will test the script and let you know if I encountered any problems or if I need any further help. Thanks again guys!

I need to rebuild the indexes on database level for nonclustered indexes in order to move them to primary file.

Can you please send the scripts? Thanks

I loved the script. I wish the author or some cold post the reverse process like moving non-clustered indexes from secondary to primary with clustered indexes.