Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / September 2007

Tip: Looking for answers? Try searching our database.

Space Required to store a file in database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
apondu - 09 Sep 2007 19:49 GMT
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 apondu@gmail.com, if someone knows the answer then
please

let me know

Thanks for the response and help people here are providing

Regards,
Govardhan.
ML - 10 Sep 2007 09:12 GMT
Perhaps...

select datalength(<your column>)
 from <your table>
 where <criteria specifying the row(s) to check>

> ...b'coz i know it'll occupy less than the original file size...

How do you know that?

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.