-
SELECT DISTINCT so.name AS 'table_name', so.object_id,sp.partition_id,si.name AS 'index_name',internals.type_desc,internals.total_pages, internals.used_pages, internals.data_pages,first_iam_page, first_page, root_page
-
FROM sys.objects so
-
INNER JOIN sys.partitions sp ON so.object_id = sp.object_id
-
INNER JOIN sys.indexes si ON sp.object_id = si.OBJECT_ID AND sp.index_id = si.index_id
-
INNER JOIN sys.allocation_units sa ON sa.container_id = sp.hobt_id
-
INNER JOIN sys.system_internals_allocation_units internals ON internals.container_id = sa.container_id
-
WHERE so.object_id = object_id('NotificationRecord');