2011年4月27日
Defrag Index and Pull fragmentation statistics in SQL Server
摘要： Pull fragmentation statistics: SELECT OBJECT_schema_NAME(a.OBJECT_ID)+'.'+OBJECT_NAME(a.OBJECT_ID)ASObjectName, a.OBJECT_IDASObjectID, a.index_idASIndexID, b.nameASIndexName, a.avg_fragmentation_... 阅读全文
posted @ 2011-04-27 13:41 Allen Xu 阅读(174) 评论(0) 推荐(0) 编辑
Reindex SQL Server DB table
摘要： DBCCDBReindex(TableName, '',90) Or ALTERINDEXALLONTableNameREBUILDWITH (FILLFACTOR=90,SORT_IN_TEMPDB=ON,STATISTICS_NORECOMPUTE=OFF,ONLINE=OFF); 90 Refers to page density 90%, 10% is reserved for updat... 阅读全文
posted @ 2011-04-27 13:20 Allen Xu 阅读(204) 评论(0) 推荐(0) 编辑