Search This Blog

20 October 2010

What is a FILESTREAM in SQL Server 2008?

A FILESTREAM is a new feature in the SQL Server 2008. It allows structured data to be stored in the database and associated unstructured data to be stored directly in the NTFS file system. Transactional consistency is maintained at all times between the structured and unstructured data. FILESTREAM combines the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system.
It is recommended to use the FILESTREAM when any of the following conditions are met:
  • When the objects that are being stored in the FILESTREAM have a size greater than 1 MB.
  • When fast read access is an essential requirement.
  • When an application is developed that uses a middle tier for application logic.

No comments:

Post a Comment