SQL Server 2005 数据维护实务

jonvi

　　USE [AdventureWorks]　　GO
　　ALTER INDEX [AK_SalesOrderDetail_rowguid]
　　ON [Sales].[SalesOrderDetail]
　　REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = ON, IGNORE_DUP_KEY = OFF, ONLINE = ON )
　　GO
　　USE [AdventureWorks]
　　GO
　　ALTER INDEX [IX_SalesOrderDetail_ProductID]
　　ON [Sales].[SalesOrderDetail]
　　REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = ON, ONLINE = ON )
　　GO
　　USE [AdventureWorks]
　　GO
　　ALTER INDEX [PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID]
　　ON [Sales].[SalesOrderDetail]
　　REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = ON, ONLINE = ON )