Determining Filegroup for a Table

Have you ever needed to figure out which filegroup your tables are located within?  If you had to do this, you might think it's as easy joining sys.tables to sys.filegroups.  But its a little more complicated than that because tables aren't stored in filegroups. It's The Indexes It's the indexes for a table that determine … Continue reading Determining Filegroup for a Table