Move GUID Index to new file group drive

[timscronin]

I have a 3rd party app which has created a new index on several large tables that are guids. None of these indexes are clustered. I have another RIAD 5 array that I was thinking of moving these indexes to. The app has about 4-500 concurrent users during ther day. Any opinions on doing this?

 

[mrdenny]

You can greate a new file group on the the drive, and move the indexes to the new file group. However this will will block access to the objects while the indexes are being rebuilt.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[timscronin]

Not a problem, this will be done during an upgrade, no users will be on