Due to the increased work to set up$,$ our author recommends using this approach to store BLOB data only when most of the BLOBs are bigger than $1$ megabyte and when fast read access is critical.

use a varbinary$($max$)$ column without FILESTREAM attribute

Using varbinary$($max$)$ column with the FILESTREAM attribute

store a string value in the database column that points to a binary file on the file system

use a varchar$($max$)$ column