- Regresar »
- Sql Server »
- Script para mostrar tablas segun su tamaño físico y numero de registros
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'
Publicar un comentario