Previous Topic: Full-Text Search CatalogsNext Topic: Performance Improvement Tips


FILESTREAM Data

In SQL Server 2008, Microsoft introduced Filestream storage. Filestream data are often very large and unstructured objects that typically reside outside of a database, such as text documents, images, videos or music files. In SQL Server 2008, Filestream data is stored in separate FileGroups that contain only file system directories instead of the Filestream objects themselves.

Note: Large FILESTREAM collections may take significant amounts of time to estimate, causing property list generation to be slow.