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 |
|
chaithanya
Starting Member
17 Posts |
 Posted - 2005-05-06 : 04:27:17
|
| I've observed huge unused space in a few databases. What is this unused space and why do it grow so large? (i.e., 3-4 times of the data and index space.)And what does a negative value in AllocatedSpace represent? Help me plz.Chaithanya J |
|
|
chaithanya
Starting Member
17 Posts |
Posted - 2005-05-18 : 07:34:29
|
Help plz..quote:
Originally posted by chaithanya
I've observed huge unused space in a few databases. What is this unused space and why do it grow so large? (i.e., 3-4 times of the data and index space.)And what does a negative value in AllocatedSpace represent? Help me plz.Chaithanya J
Chaithanya J |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
kish
Starting Member
45 Posts |
Posted - 2005-05-18 : 08:20:54
|
| Unused space is the space not used by your data or log files. It all depends on your filegrowth size or % set by you. --Kishore |
|
|
|
|
|
|
UnusedSpace