-- taille des bases de données
WITH
T1 AS
(
SELECT SUM(CONVERT(BIGINT,CASE WHEN STATUS & 64 = 0 THEN SIZE ELSE 0 END)) AS dbsize,
       SUM(CONVERT(BIGINT,CASE WHEN STATUS & 64  0 THEN SIZE ELSE 0 END)) AS  logsize
FROM dbo.sysfiles
),
T2 AS
(      
SELECT SUM(a.total_pages) AS reservedpages,
       SUM(a.used_pages) AS usedpages,
       SUM(CASE
                    WHEN it.internal_type IN (202,204,211,212,213,214,215,216) THEN 0
                    WHEN a.TYPE  1 THEN a.used_pages
                    WHEN p.index_id = reservedpages
             THEN(dbsize - reservedpages) / 131072.0  
          ELSE 0
       END AS unallocated_space_GO,
       reservedpages / 131072.0    AS reserved_G0,
       pages / 131072.0   AS data_GO,
       (usedpages - pages) / 131072.0    AS index_size_GO,
       logsize / 131072.0    AS log_size_GO,
       (reservedpages - usedpages) / 131072.0    AS unused_GO      
FROM   T1 CROSS JOIN T2;