删除重复记录,将TABLE_NAME中不重复记录保存到#TABLE_NAME中
select distinct * o #table_name from table_name
delete from table_name
select * o table_name from #table_name
drop table #table_name
和此相关是“select o”选项可以在数据库属性
对话框中勾起来此项或者在Query Analyzer中执行
execute sp_dboption 'db_name','select o','true'
开启默认值是关闭

*******************************************************
收缩事务日志(多次执行)
backup log register with NO_LOG
backup log register with TRUNCATE_ONLY
DBCC SHRINKDATABASE(register)