Feb
27
2012

FILESTREAM filegroups can contain multiple files in SQL Server 2012

This post describes a new FILESTREAM feature in SQL Server 2012 that enhances the I/O scalability of FILESTREAM data. In SQL Server 2012, a FILESTREAM filegroup can now contain more than one file. You can improve I/O scalability for FILESTREAM data by placing different files within the same FILESTREAM filegroup on different volumes. This feature eliminates the need for complicated workarounds that use partitioning and multiple FILESTREAM filegroups. The following example creates the BlobStore1 database. The... [More]