New answers tagged blob
If it's the textual content of the files you are concerned with and you need to search that content, store it as [n]varvchar(max) and consider using a full-text index on the column. If the files are XML, consider storing the content using the xml data type. If the files are some format other than plain text and you want to preserve that format, use BLOB ...
Top 50 recent answers are included