如何查询SQL Server中最新岛的大小？

SELECT
    OBJECT_NAME(i.object_id) AS TableName,
    i.name AS IndexName,
    SUM(s.used_page_count) * 8 AS IndexSizeKB
FROM
    sys.dm_db_partition_stats AS s
INNER JOIN
    sys.indexes AS i ON s.object_id = i.object_id AND s.index_id = i.index_id
WHERE
    OBJECT_NAME(i.object_id) = 'YourTableName'
GROUP BY
    OBJECT_NAME(i.object_id),
    i.name
ORDER BY
    OBJECT_NAME(i.object_id),
    i.name;