• a.rajmane (9/3/2009)


    Will enabling filestream help if its not a BLOB?

    I'm not sure exactly what you mean, but I will try to clarify in hopes that it answers your question.

    In a traditional varbinary(MAX) field without FILESTREAM, the data is stored as a blob in the database. With FILESTREAM, the binary data is stored in the file system as an actual file, of any type. It could be a MS Word document, image file, PDF, or most any other type regular file. Therefore, whatever methods are available through ASP.NET, T-SQL, etc. to import or retrieve the data, the core data is an actual file where the database is simply storing a pointer to that file.

    I hope that helps.