Thanks for your earlyer comments, but now i have a problem:
1. I have backed up the database
2. i've made 2.5 GB deletes in small batches
3. This table only has a clustered index on an PK Column,
i have performed a DBREINDEX on that Pk clustered index.
Results:
name
Table_name
rows reserved data index_size unused
221392 4902000 KB 2724296 KB 112 KB 2177592 KB
How can i free the unused table space ?? Why the
dbreindex didin't release this space ?
Sorry
Can you help me ?Thanks again
Mike
..
Delete OF 2.5 GB (Cont.)
No comments:
Post a Comment