MSSQLٻƣЧɼٶȣȫҪ뵽У

ʹִд룺


Create INDEX ½_ ON ½(½,,С˵) 
Create INDEX С˵_ ON С˵(,,ʱ,ע,ؼ,,,״̬) 


ͬʱMSSQLײƬ鶨ʹĲѯ룺


DBCC DBREINDEX(С˵,'',90)
DBCC DBREINDEX(½,'',90)
backup log ݿ with NO_LOG 
backup log ݿ with TRUNCATE_ONLY 
DBCC SHRINKDATABASE(ݿ)


ִʱûִд֮ǰرݣммǣ



裺

	1ҵ 
	2Ҫݿ 
	3˵> > SQLѯ 

ϱ߶Ӧ룬ɣ