|
|
Posted by Erland Sommarskog on 09/09/07 22:24
apondu (apondu@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?
If the word document is 5MB on disk, it will take up 5MB in the database
plus some over head that I would expect to be small, at most 1%. The only
way you can make it take up less then 5MB is to compress it before you store
it.
--
Erland Sommarskog, SQL Server MVP, esquel@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
Navigation:
[Reply to this message]
|