Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2008-07-29 : 16:54:40
|
| Folks,From my experience, rebuilding indexes (while might require addition space to be done), frees up (sometimes a lot of) space after the procedure is completed.My question is: Is there a way to know exactly (or approximately) how much space will be regained after the REBUILD INDEX is done with [i.e. without performing the actual REBUID INDEX]?Thanks a lot! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-29 : 22:25:01
|
| You can run 'dbcc showcontig' and look at 'Avg. Page Density (full)', it should close to 100% (depends on row size) after rebuild clustered index if you don't specify fill factor. Compare two results to get idea roughly. |
 |
|
|
|
|
|
How to predict space gain after REBUILD INDEX?