For various databases including WWF I use a free utility called expressmaint.sql which is installed in MASTER.
I call this utility manually once in a while using the following stored procedure:
USE [wwf]
GO
/****** Object: StoredProcedure [dbo].[iReindex] Script Date: 07/10/2011 19:52:36 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[iReindex] AS
exec master.dbo.expressmaint
@database = 'wwf',
@optype = 'REINDEX',
@report = 0
dbcc shrinkdatabase(wwf, truncateonly)
exec sp_updatestats
Topic Options
Post Options
Thanks(0)
