FILESTREAM is a new feature in the SQL Server 2008 release. It allows structured data to be stored in the database and associated unstructured (i.e., BLOB) data to be stored directly in the NTFS file system. You can then access the BLOB data through the
high-performance Win32 streaming APIs, rather than having to pay the performance penalty of accessing BLOB data through SQL Server. This demo provides a basic introduction to optimally storing large binary data using the new Filestream data type included in
SQL Server 2008 that takes advantage of the best of both worlds (file system and transactional database).
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.