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 |
|
cr8nk
Yak Posting Veteran
77 Posts |
 Posted - 2001-10-29 : 21:54:59
|
| Hello there,I a database with 3.5 GB reserved space for data. I only have 500 MB data in the database, but after running a lot of data modification queries, I ended up with 2.5 used data space (not transaction log). The data in my tables only still only added up to 500 MB. Anyone know why the space used in the data file shows to be bigger than the actual amount of the data in the tables & indexes?thanks,Creighton |
|
|
|
|
|
data space used not equal to amount of data