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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-14 : 08:20:00
|
| karen writes "In several large databases, I've noticed that sp_spaceused (when run for a table) shows that although SQL has reserved 44123840KB, it reports that 22061824KB is unused. In these databases, this seems to be true for all large tables, however, I have other very similar databases where the unused space shows as very small. Why would sql server reserve so much space for some databases? I" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-14 : 08:41:27
|
| Index rebuilds, deletion of data, etc. Many times, this space is:1. Transaction log space, which will not be reclaimed until you shrink the file.2. Index and table space from deletions and index rebuilds. Again, this can be fixed by shrinking the files.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
sp_spaceused, how sql reserves space