Hi, I have a 47G database. I did a "DBCC Dbredindex" on one table. After 4 hours, It did not finish, So I canceled it. Then I check the space of database. It is 89G. I used the "Sp_spaceused " to check all the table space, then add them together. It is around 47G. What is going on to my database? what objects take other 40G space? how can I shrink this database and do not affect performance? Thanks in advance.