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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-19 : 10:10:39
|
| Anastasia writes "Dear people, I am working with SQL Server only couple of month, so if the question is too simple - go easy on me. I have read about the benefits of placing tables and indexes on specific filegroups.Which would be the best way to recreate existing nonclustered indexes on new filegroup for the whole database at once?Scripting tables and indexes with EM and modifying script or there are some other ways?Can someone point me in right direction.Thanks a lot." |
|
|
|
|
|
Indexes on separate filegroup