SQL Server - Indexes

indexes.sql

SELECT t.name AS [TableName]
     , i.name AS [IndexName]
     , i.is_primary_key
     , i.is_unique_constraint
     , i.type_desc
     , SUM(s.[used_page_count]) * 8 AS IndexSizeKB
  FROM sys.indexes i
  JOIN sys.tables t ON t.object_id = i.object_id
  JOIN sys.dm_db_partition_stats s ON s.object_id = i.object_id AND s.index_id = i.index_id
 GROUP BY t.name 
     , i.name 
     , i.is_primary_key
     , i.is_unique_constraint
     , i.type_desc