I found the following post: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23262864.html?sfQueryTermInfo=1+10+2005+filegroup+server+sql
and Chapmandew's solution (see code below) is awesome...I would just like to take a step further. Being a newbie to SQL Server though, I just can't seem to figure out how.
Ideally, I would like the tablename, its filegroup, the size of the table and the size of the indexes in the filegroup as well in a result from running the query. Is this possible, or is there a tool that lets you do that? I know I can look at the filegroups and see how big they are, it just doesn't show me what is in them and what accounts for what percentage of space. This would be useful in keeping the filegroup sizes under control for maximum performance.
select tablename = object_name(object_id),Data_located_on_filegroup = d.name
from sys.data_spaces d
join sys.indexes i on d.data_space_id = i.data_space_id
where i.index_id < 2