The following query will return the results of the tables created by the user on different Filegroup in a particular database . SELECT distinct o.[name], o.[type], f.[name] FROM sys.indexes i. …

Jan 11, 2017 · I can look up the SSMS > Object Explorer > Properties > Storage on the each table and other objects to see what file group they belong to, but it might not be a feasible solution …

Jan 27, 2011 · Query to determine table filegroup by index and partition SELECT t.name AS table_name ,i.index_id ,i.name AS index_name ,p.partition_number ,fg.name AS …

May 12, 2014 · If you have a database with multiple physical files, you can group each file in a filegroup and store a table or a clustered index in the filegroup you prefer.

May 22, 2013 · No matter even if your data is spread over any number of data files but still you can use INFORMATION_SCHEMA.TABLES to get the list of tables. TABLES Overview The …

Oct 3, 2014 · Is it possible to get an overview of all the tables and indexes to see which filegroup they are stored? This tip will continue the series of Administration Intelligence and will provide …

Apr 12, 2012 · You need to be more specific. You can determine the data files that are available in a database by saying: SELECT name, physical_name, state_desc, size, max_size, …

Jan 22, 2013 · Is there a way to find in which data file the particular table exists. Thanks in advance. A table doesnt exist on a data file, it exists on a file group. Are the MDF and NDF in …

WHERE f. file_id IN (13,14) AND AU.total_pages > 0 — Look at specific files, could also filter on file group. ORDER BY AU.total_pages desc — Order by size –DS.name –,SCH.name …

Dec 13, 2011 · It is possible to find exactly how each rowset page lays out in each file by chasing the IAM chains manually, or by using undocumented features like DBCC IND or …