Summary
For applications that work with BLOB data, FILESTREAM greatly enhances the storage and performance of unstructured content in the database by leveraging the native NTFS file system. It does this while maintaining logical integration between the database and file system that includes transactional support. As a result, you no longer need to compromise between efficiency and complexity as you did in the past when faced with the choice of storing BLOB data inside or outside the database.
You also learned how to use SqlFileStream to deliver high-performance streaming of BLOB content between the file system managed by SQL Server and your Windows, web, and WPF applications. Finally, you learned how FileTable in SQL Server 2012 combines FILESTREAM ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
