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 |
|
Christina Agyeman
Starting Member
15 Posts |
 Posted - 2002-10-03 : 06:41:23
|
| It is advisable when separating data and indexes on different physical disk, to place all data on one disk and indexes on another or clustered index and data on one disk and non clustered indexes on another.Please help |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-03 : 06:52:39
|
| You might get better performance with indexes on a separate disk and controller (you can't separate clustered index and data because the data is part of the index). But you are probably better off spending the time thinking about the design rather than things like this, it will make a lot more difference.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Indexes on seperate disk