Posts Tagged: Disk Space

Simply start a new query window for the database and use the statement below: SELECT object_name(i.object_id) as objectName, i.[name] as indexName, sum(a.total_pages) as totalPages, sum(a.used_pages) as usedPages, sum(a.data_pages) as dataPages, (sum(a.total_pages) * 8 ) / 1024 as totalSpaceMB, (sum(a.used_pages) * 8 ) / 1024 as usedSpaceMB, (sum(a.data_pages) * 8 ) / 1024 as dataSpaceMB FROM… Read Article →

Scroll To Top