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

Hi,

When you create a clustered index, you have to understand that you need two
times more than data size plus some space for index structure. (Typically it
should be about 20 percent). Read CREATE INDEX statement in BOL and
everything will be clear.

Tomasz B.

"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
>