"randy" wrote:

> I work in ETL and had a table clustered index create fail
> to due to the filegroup being full. Its created after
> the data is inserted. I just read where I could use the
> create in tempdb option, but here I don't think that
> would help.
>
> What I am thinking to minimize the space needed, is to
> change and have the text file that loads into the table
> be sorted to match the clustered index?
>
> Would that help reduce the space needs when creating the
> clustered index? I gotta beleive it would, but can't
> find it in sql 2000 book. Can anyone confirm.
>
> tia
> Randy
>
> the table is about 2,000 meg & 4 million rows