----------删modify
declare @maxsysindex INTEGER
select @maxsysindex = MAX(F_sysindex) from T_MODIFYLOG
delete from T_MODIFYLOG where F_sysindex < @maxsysindex



-----------优化
DECLARE @name varchar(100)

DECLARE authors_cursor CURSOR FOR  
Select [name]   from sysobjects where xtype='u' order by id

OPEN authors_cursor

FETCH NEXT FROM authors_cursor  INTO @name

WHILE @@FETCH_STATUS = 0 
BEGIN    

   DBCC DBREINDEX (@name, '', 95)

   FETCH NEXT FROM authors_cursor  
   INTO @name 
END

deallocate authors_cursor



-----------收缩
USE[master]
GO
ALTER DATABASE 柳市新鸿成足道 SET RECOVERY  SIMPLE WITH NO_WAIT
GO
ALTER DATABASE 柳市新鸿成足道 SET RECOVERY SIMPLE--简单模式
GO
USE 柳市新鸿成足道
GO
DBCC SHRINKFILE(N'HDWMSDB_log', 11,TRUNCATEONLY)
GO
USE[master]
GO
ALTER DATABASE 柳市新鸿成足道 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE 柳市新鸿成足道 SET RECOVERY FULL--还原为完全模式
GO