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)?