New Storage Features
SQL Server 2008 provides a set of new features to reduce storage requirements and improve performance.
One of the new features is FILESTREAM storage. FILESTREAM storage is a property that can be applied to varchar(max) columns; it enables SQL Server applications to store unstructured data, such as documents and images, directly in the NTFS file system while still maintaining the behavior of a database column. The advantages of FILESTREAM storage are improved performance and increased size of BLOB data, expanding from the 2GB limit of image columns to the available space in the file system. For more information on using FILESTREAM storage, see Chapter 42, “What’s New for Transact-SQL in SQL Server 2008.”
Other storage features ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
