Space Required to store a file in database

9 Sep 2007 6:55 PM

apondu

hi,

I had a query on sql database, we know we usually store files of

different type in sql database and its helpful for searching and

retrieving the documents from the database, but one query i had was

related to the amount of space required to store the files in the

database. For Eg., say i have a word document which is of 5Mb thn how

much space does it occupy in the database if i store it in binary
format

b'coz i know it'll occupy less than the original file size but i
wanted

to knw exactly how much space it'll take in the database and y?

my mail-id is apo***@gmail.com, if someone knows the answer then
please

let me know

Thanks for the response and help people here are providing

Regards,
Govardhan.

9 Sep 2007 10:27 PM

Erland Sommarskog

apondu (apo***@gmail.com) writes:

> I had a query on sql database, we know we usually store files of
> different type in sql database and its helpful for searching and
> retrieving the documents from the database, but one query i had was
> related to the amount of space required to store the files in the
> database. For Eg., say i have a word document which is of 5Mb thn how
> much space does it occupy in the database if i store it in binary
> format
> b'coz i know it'll occupy less than the original file size but i
> wanted
> to knw exactly how much space it'll take in the database and y?

This question was also posted to comp.databases.ms-sqlserver. Please
do not post the same question independently to different newsgroups.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx