sQL 2005 找出占用空間最大的表
--exec usp_deleteAsyncOperationBase
declare @name nvarchar(200)
declare @rs table (name nvarchar(200), rows nvarchar(20), reserved nvarchar(50), data nvarchar(50), index_size nvarchar(50),unused nvarchar(50))
declare currs cursor FORWARD_ONLY for
SElect name from sys.objects where type=N'U' and schema_id=1
open currs
fetch next from currs into @name
while @@fetch_status=0
begin
insert into @rs
exec sp_spaceused @name
fetch next from currs into @name
end
close currs
deallocate currs
update @rs set data=left(data,len(data)-2)
select * from @rs order by convert(int,data) desc
declare @name nvarchar(200)
declare @rs table (name nvarchar(200), rows nvarchar(20), reserved nvarchar(50), data nvarchar(50), index_size nvarchar(50),unused nvarchar(50))
declare currs cursor FORWARD_ONLY for
SElect name from sys.objects where type=N'U' and schema_id=1
open currs
fetch next from currs into @name
while @@fetch_status=0
begin
insert into @rs
exec sp_spaceused @name
fetch next from currs into @name
end
close currs
deallocate currs
update @rs set data=left(data,len(data)-2)
select * from @rs order by convert(int,data) desc
浙公网安备 33010602011771号