Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Problemkilla
Starting Member
4 Posts |
 Posted - 2002-02-28 : 08:46:11
|
| I am in the process of reorganizing the database structure of my largest database. I have created a new filegroup and populated it with a .NDF file. I have placed it on a different disk and disk controller as suggested by BOL. However, I need a good method for moving all non-clustered indexes into the INDEX filegroup. I know that you need to drop and create them in the new Filegroup.Are there any good scripts that you have come across to do this sort of thing? I would have to imagine there is something already made. I just don't want to re-invent the wheel. Thanks in advance for your help. |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-28 : 11:29:20
|
| There is a very buggy stored proc called sp_IndexKeyText that can be found here. http://www.swynk.com/sqlscripts/index7.asp Like I said, it does have quite a few bugs, but I suppose it is still better than starting from scratch. Edited by - izaltsman on 02/28/2002 11:31:32 |
 |
|
|
Problemkilla
Starting Member
4 Posts |
Posted - 2002-02-28 : 12:11:15
|
| Thanks for your help. |
|
|
|
|
|
|
Moving Non-Clustered Indexes to new Filegroup