Table Space Query - data and index size
Posted on 2010-09-20
I have a n SQL Server 2000 database which has data imported each night into it.
The import has been failing for the past few nights so I am investigating as to why.
Now I have noticed that when I use the SPROC sp_spaceused to check the tables for size, I have 2 tables that currently contain 0 rows but the space used shows as:
Data: 109264 KB
index_size: 11360 KB
Data: 8988288 KB
index_size: 28880 KB
Both tables have primary keys and auto increment set and each night these tables are truncated before new data is inserted. But at the moment these tables are empty.
Can anyone advise why there would be so much data still attached to these tables even though there isn't any rows?