Advertisement
etsuskier

Filegroup Usage

Dec 15th, 2015
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. SELECT OBJECT_NAME(p.object_id) AS table_name,
  2.        p.index_id,
  3.        p.rows,
  4.        au.type_desc
  5.   FROM sys.partitions AS p
  6.  INNER JOIN sys.allocation_units AS au ON p.hobt_id = au.container_id
  7.  INNER JOIN sys.filegroups AS f ON au.data_space_id = f.data_space_id
  8.  WHERE f.name = 'YourFilegroupName'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement