FILESTREAM uses NT System Cache for caching file data.

updating a view in sql server-8

Moreover management (backup, restore, security etc) of the data will be a pain too.

FILESTREAM was introduced in SQL Server 2008 for the storage and management of unstructured data.

If the SQL Server 2008 instance is already installed without FILESTREAM feature, it can still be enabled following the steps explained later in this section.

The easiest way to enable FILESTREAM feature is to do so as part of the installation process.

The other approach is to store the unstructured data as disk files and store the location of the file in the table along with the other structured data linked to it.

This approach was found to be good in terms of performance, but does not ensure transactional consistency.

The FILESTREAM feature can be enabled by setting the appropriate options on this page.

If you wish to automate this process, you could try running the VBScript given at How to enable FILESTREAM from the command line. Once FILESTREAM feature is enabled, the next step is to configure FILESTREAM Access Level.

When the FILESTREAM attribute is set, SQL Server stores the BLOB data in the NT file system and keeps a pointer the file, in the table.