Space allocation error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

randy - 19 Jan 2005 22:38 GMT

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

Reply to this Message

Tomasz Borawski - 11 Feb 2005 14:11 GMT

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.

> I work in ETL and had a table clustered index create fail
> to due to the filegroup being full. Its created after
[quoted text clipped - 14 lines]
>
> the table is about 2,000 meg & 4 million rows

Reply to this Message