-- Могу подарить свою - но есть и системные, но в основном недокументированные.



CREATE PROCEDURE SP_HelpAllTab
AS set nocount on
-- 0000000000000000000000000000000000000000000000000000000000000000000000000000000
-- ***************** < О Б'Е М Ы Т А Б Л И Ц > ******************************
declare @dat_size decimal(15,2),@ind_size decimal(15,2),@name_O sysname,
@res_size decimal(15,2),@upl_size decimal(15,2),@id int,@r int, @i int,
@page_MB decimal(15,2),@unu_size decimal(15,2)
select @page_MB=1048576/low from master.dbo.spt_values
where number = 1 and type = 'E' -- Размер страницы SQL Server в Мегабайтах
declare @stoTabl table (NAME sysname, ROWS int,USE_SIZE varchar(15),
DAT_SIZE varchar(15),IND_SIZE varchar(15),
AVG_LENGTH varchar(15))
declare cur_SelTabStoDB cursor local for select name,id from sysobjects
where xtype = 'U' and status >= 0 and OBJECTPROPERTY(id,N'IsUserTable') = 1
open cur_SelTabStoDB
fetch next from cur_SelTabStoDB into @name_O,@id
while (@@FETCH_STATUS != -1) begin if (@@FETCH_STATUS != -2) begin
select @r=rows from sysindexes where id = @id and
indid = (select min(indid) from sysindexes where id = @id)
select @dat_size=sum(convert(decimal(15),dpages)) -- Под данные
from sysindexes where indid < 2 and id = @id
select @dat_size=@dat_size+isnull(sum(convert(decimal(15),used)), 0)
from sysindexes where indid = 255 and id = @id
select @ind_size=sum(convert(decimal(15),used))-@dat_size -- Под индексы
from sysindexes where indid in (0, 1, 255) and id = @id
select @unu_size=case when @r = 0 then 0 else (@dat_size*@page_MB)/@r end,
@dat_size=@dat_size/@page_MB,@ind_size=@ind_size/@page_MB,
@res_size=@dat_size+@ind_size -- Всего
insert into @stoTabl values (@name_O,@r,str(@res_size,15,2),
str(@dat_size,15,2),str(@ind_size,15,2),str(@unu_size,15,2)) end
fetch next from cur_SelTabStoDB into @name_O,@id end
close cur_SelTabStoDB deallocate cur_SelTabStoDB
insert into @stoTabl select '@@Total',sum(ROWS),
str(sum(convert(decimal(15,2),USE_SIZE)),15,2),
str(sum(convert(decimal(15,2),DAT_SIZE)),15,2),
str(sum(convert(decimal(15,2),IND_SIZE)),15,2),'' from @stoTabl
select * from @stoTabl order by NAME
if (select count(*) from @stoTabl) = 0 return 3
return 0