SqlServer-QA.net

To continue the FIND-FilegroupFull post on the filegroups, here is the most common question on the forums to get which object reside under which filegroup if there are multiple ones associated:   select si.rows as 'Rows', SO.Name as Table, SI.name as 'Index', SFG.groupname as 'Filegroup' from sysobjects as SO    join ...