Rozmiar tabel

declare @tab table
(_name varchar(50),
_rows int,
_reserved varchar(50),
_data varchar(50),
_index_size varchar(50),
_unused varchar(50),
_reservedInt int,
_dataInt int,
_index_sizeInt int,
_unusedInt int
)


declare @nazwa varchar(50)

declare kursor cursor forward_only FOR
select name from sys.objects

where type_desc= 'USER_TABLE'
and schema_id = 5
open kursor
FETCH NEXT FROM kursor INTO @nazwa

    while @@FETCH_STATUS = 0
    begin
    SET @nazwa = 'CDN.'+@nazwa
    insert into @tab (_name,
_rows,
_reserved,
_data,
_index_size,
_unused)
    exec sp_spaceused @nazwa

    print @nazwa

    FETCH NEXT FROM kursor INTO @nazwa
    End
close kursor
DEALLOCATE kursor

UPDATE @tab SET _reservedInt = Convert(int, CASE Right(_reserved,2) WHEN 'KB' THEN Left(_reserved,Len(_reserved)-3) ELSE 0 END ),
_dataInt = Convert(int, CASE Right(_data,2) WHEN 'KB' THEN Left(_data,Len(_data)-3) ELSE 0 END ),
_index_sizeInt = Convert(int, CASE Right(_index_size,2) WHEN 'KB' THEN Left(_index_size,Len(_index_size)-3) ELSE 0 END ),
_unusedInt = Convert(int, CASE Right(_unused,2) WHEN 'KB' THEN Left(_unused,Len(_unused)-3) ELSE 0 END )

select * from @tab
select _name, _reservedInt + _dataInt + _index_sizeInt + _unusedInt as Rozmiar from @tab
ORDER BY _reservedInt + _dataInt + _index_sizeInt + _unusedInt DESC