Hi Jeff ,

hmm I just did defragmentation for all indexes in that particular database as discussed before .

It turns out the database file size is the same ( before and after defragmentation ) ....

I did REBUILD for indexes that has more than 50 % of fragmentation and did REORGANIZE for the rest ..

Moreover as the side effect from defragmentation , the transaction log increase and full up the poor harddisk that has liitle space already ...

I did the maintenance in temporary new hard drive ( 100 GB) and did the backup of transaction log in order to decrease the log file size but tomorrow i need to give back the new hard drive ....

Any idea about this case ?