FILESTREAM and SQL 2008 and Document Storage

Westside2004
Westside2004 used Ask the Experts™
on
Hi,

I am building a document repository and I wanted to store my documents in the database and make use of the new FILESTREAM functionality.  In the docs it suggests that the documents should be over 1MB in size.    For my project I would say only 10% of the documents will be over 1MB.  Most of my documents are between 40k and 500k I would say.

1. Does it still make sense to use FILESTREAM?

2.  If I don't use FILESTREAM, do I just store the binary data in a column that has a datatype of varbinary(MAX)?

Thanks,

-ws
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
remove the ? from my previous comment: http://research.microsoft.com/apps/pubs/default.aspx?id=64525

Author

Commented:
Yes, I've seen that, it applies to large objects though.
Senior .Net Consultant
Top Expert 2016
Commented:
it doesn't that you shouldn't use it. It only says that the overhead pays when files are large. But there are so many benefits (backup, security, full text search, ...) that I use it even for smaller files.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial