December 19, 2003 at 10:38 am
I have a database with single table about 100 mil records and 10 GB used space
and 10 GB free space. I need to keep the free space 10 GB all the time, since
every time I create the index (with sort in tempdb) the database uses this space
during the indexing. When the indexing is done the db has 10 GB free space again.
When I tried to shrink the database after the index was created to claim the space,
that left the table badly fragmented, so had to expand the db and recreate the index
again to keep the fragmentation low. So looks like I have to keep the 10 GB free space,
which is same as the size of the table, all the time. How do you guys deal with
this kind of situation, do you keep the free space enough to reorg your largest
table all the time?
Thanks.
December 19, 2003 at 11:27 am
Yes.
--Jonathan
--Jonathan
December 19, 2003 at 5:01 pm
quote:
do you keep the free space enough to reorg your largesttable all the time?
You have to ensure more than 1.2 times spaces of your table available if there is clustered indexon that table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply