Moving clustered index 1

[andreis]

Hi, on SQL Server 2000 db we have a huge table (10GB).
We ran out of space, can't add space to data disk for whatever reason.
I'm creating .ndf file to recreate indexes on another drive.
What happens if I recreate a clustered index on another drive for such a huge table?
When they say clustered index is physical data, does it mean data would be moved to this new drive?
I can't do that, not enough space for data.
Also, would performance suffer from indexes moved to another drive?
It's production, so I try not to make stupid moves.
Any shared experience would be greatly appreciated.
Thanks.

 

[mrdenny]

Performance usually increases when you put the indexes on another physical disk.

If you move the clustered index to another disk the table will be moved with it.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog