set nocount on;
declare @name sysname;

declare cur1 cursor for
	select ss.name + '.'+ tt.name obj
	from sys.tables tt
	inner join sys.schemas ss on tt.schema_id = ss.schema_id

create table #result1 (name sysname, rows bigint, reserved varchar(100), data varchar(100), index_size varchar(100), unused varchar(100))
create table #result (name sysname, rows bigint, reserved bigint, data varchar(100), index_size varchar(100), unused bigint)

open cur1
fetch cur1 into @name
while @@FETCH_STATUS = 0
begin 
	insert #result1
		exec sp_spaceused @objname = @name;
	insert #result 
		select @name, rows, cast(replace(reserved, ' kb', '') as bigint), data, index_size, cast(replace(unused, ' kb', '') as bigint) from #result1
	delete #result1

	fetch cur1 into @name
end

close cur1
deallocate cur1

select *, iif(unused = 0, 0.01, unused)/iif(reserved = 0, 0.01, reserved) * 100.00 waste_pc from #result where reserved > 100000 order by 7 desc