Sayfalar

30 Aralık 2014 Salı

MsSQL Database Index Düzeltme


declare @name varchar(100)
BEGIN
DBCC SHOWCONTIG
DECLARE reindex CURSOR FOR
select name from sysobjects where type='U' order by name
OPEN reindex
FETCH NEXT FROM reindex INTO @name
WHILE @@FETCH_STATUS =0
BEGIN
DBCC DBREINDEX (@name, '', 90)
print @name + ' duzenlendi....'
FETCH NEXT FROM reindex INTO @name
END
CLOSE reindex
DEALLOCATE reindex
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
DBCC SHOWCONTIG
END

Hiç yorum yok:

Yorum Gönder