FILESTREAM data for the table must be stored in a single filegroup that is specified in the FILESTREAM_ON clause. FILESTREAM_ON NULL can be specified in a CREATE INDEX statement if a clustered index ...
Note When you drop or rebuild large indexes, or drop or truncate large tables, the [!INCLUDE ssDE] defers the actual page deallocations, and their associated locks, until after the transaction commits ...