Publicado por: Carlos lunes, mayo 23, 2011

Select Tabla,
       cast(Reservado    * d.low as int) ReservadoKB,
       cast(Data         * d.low as int) DatosKB,
       cast((Usado-Data) * d.low as int) IndicesKB,
       cast((Reservado-Data) * d.low as int) NoUsadoKB,
       registros
from (
select left(o.name,35) Tabla, o.id, ii.reserved Reservado,
      isnull(ip1.pages, 0) + isnull(ip2.pages, 0) data,
      ip3.usado,   --indexp= usado - data    no usado = reserved - usado
      r.Registros
from sysobjects o
inner join sysindexes ii on o.id = ii.id
inner join (select id, sum(dpages) pages from sysindexes where indid < 2 group by id) ip1
     on o.id = ip1.id
left  join (select id, isnull(sum(used), 0) pages from sysindexes where indid = 255 group by id) ip2
     on o.id = ip2.id
inner join (select id, sum(used) Usado from sysindexes where indid in (0, 1, 255) group by id) ip3
     on o.id = ip3.id
inner join (select id, rows Registros from sysindexes where indid < 2) r
     on o.id = r.id
where o.xtype = 'U'
and   ii.indid in (0, 1, 255)
) A, master.dbo.spt_values D
where D.number = 1
and   D.type = 'E'

Populares!

- Copyright © - Oubliette - -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -