USE [TBSData] GO ALTER INDEX [IX_tDataCollection_BatchID_RevFlg] ON [dbo].[tDataCollection] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tDataCollection_DialledNumber] ON [dbo].[tDataCollection] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tDataCollection_ID_Var01] ON [dbo].[tDataCollection] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tDataCollection_RateDescription] ON [dbo].[tDataCollection] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201409_Batch] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201409_CustomerID] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201409_Element] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201409_Invoice] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201409_Payable] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201409_Service] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [PK_tFinalisedTransaction201409] ON [dbo].[tFinalisedTransaction201409] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201410_Batch] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201410_CustomerID] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201410_Element] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201410_Invoice] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201410_Payable] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201410_Service] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [PK_tFinalisedTransaction201410] ON [dbo].[tFinalisedTransaction201410] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201411_Batch] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201411_CustomerID] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201411_Element] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201411_Invoice] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201411_Payable] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201411_Service] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [PK_tFinalisedTransaction201411] ON [dbo].[tFinalisedTransaction201411] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201412_Batch] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201412_CustomerID] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201412_Element] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201412_Invoice] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201412_Payable] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IX_tFinalisedTransaction201412_Service] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [PK_tFinalisedTransaction201412] ON [dbo].[tFinalisedTransaction201412] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [IXtRateDescription_Description] ON [dbo].[tRateDescription] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) GO USE [TBSData] GO ALTER INDEX [PK_tRateDescription] ON [dbo].[tRateDescription] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF )