10gb size of Index rebuild when space left overall 5gb

Question

10gb size of Index rebuild when space left overall 5gb

hcip.77

Ten Centuries

Points: 1067
More actions
March 2, 2015 at 7:25 pm

#315155

I have 10 Gb index and disk space only left 5gb .
How can i rebuild index ?
I appreciate your time.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 1

hcip.77 (3/2/2015)
I have 10 Gb index and disk space only left 5gb .
How can i rebuild index ?
I appreciate your time.

Not many choices left. You're going to need a bigger hard disk or at least add a harddisk and put a new filegroup on it... unless...

Is it a clustered or non-clustered index?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

hcip.77 Ten Centuries Points: 1067 More actions · Answer 2

hcip.77

Ten Centuries

Points: 1067

March 3, 2015 at 7:20 am

#1781345

It is clustred.

Thank You.

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 3

hcip.77 (3/3/2015)
It is clustred.
Thank You.

In that case, you don't have the room to do a REBUILD. If your log file is on a different drive, you could try doing a REORGANIZE, instead.

As a bit of a sidebar, disk space is one of the less expensive commodities there is. There's no reason to be so cramped on disk space. I'd fix that little problem first and then you won't have this problem.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

hcip.77 Ten Centuries Points: 1067 More actions · Answer 4

Thank You Very much for valuable input.

Much appreciated.