查看文件组相关

--1. 查看DB中有多少个文件组
SELECT * FROM sys.filegroups
--2. 查看文件相关联的文件组
SELECT df.[name],
       df.physical_name,
       df.[size],
       df.growth,
       f.[name] [filegroup],
       f.is_default
FROM   sys.database_files df
       JOIN sys.filegroups f
            ON  df.data_space_id = f.data_space_id
--3. 查看某个表属于哪个文件组
----3.1. 在众多结果中找到 [ Data_located_on_filegroup ]
sp_help 'tableName'

----3.2 
SELECT o.[name],
       o.[type],
       i.[name],
       i.[index_id],
       f.[name] AS [filegroup_name]
FROM   sys.indexes i
       INNER JOIN sys.filegroups f
            ON  i.data_space_id = f.data_space_id
       INNER JOIN sys.all_objects o
            ON  i.[object_id] = o.[object_id]
WHERE  o.[TYPE]='U' 
	   AND o.name IN ('tableName')