July 17, 2006 at 1:50 pm
Hi everyone,
I have a question I have a simple table in my SQL-2000 database which is used to store documents in the database. The documents are stored in an image field. Now the problem I stored about 3300 records and the documents stored are about 100 mb. But the table uses a lot more space namely about 700 mb so 600 mb of data is unused. So 600 mb is wasted, is there anything that you can do to reduce the unused space?
This shows the data used:
Tablename: tblDocument
Rows: 3351
Reserved: 741520 KB
Data: 106904 KB
Index_size: 16 KB
unused: 634600 KB
This is the table dafinition:
tblDocument (design)
==================================================
DocumentID bigint 8 0
TPID bigint 8 0
Object varchar 255 1
ObjectID bigint 8 1
Type int 4 1
ParentId bigint 8 1
DocumentAlgemeenID bigint 8 1
Name varchar 255 1
Description varchar 2000 1
ContentType varchar 255 1
ContentLength bigint 8 1
DocumentDate datetime 8 1
DocumentName varchar 255 1
ImageSrc varchar 255 1
Document image 16 1
I hope anyone nows because it's going to cause a problem for me.
--
Best regards,
P. Keukens
July 18, 2006 at 9:06 am
You don't have to post a question twice.
Responses are here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=294968
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply