I recently got asked by our director to look into capabilities of storing documents data like MS Word and Text file to SQL Server.

Based on my knowledge I think you can only use TEXT data type for such need but it is not good in performance and doesn't support full functionality that varchar does which is limited to 8000 characters.

I would like to know if we have any other options specific to SQL Server? Any help would be appreciated.

-Asim