rebuild index

  • Hi ,

    i have created a maintance plan to rebuild index with online.In job history i found below error.Can any help me plz.

    "Progress: 2012-02-02 01:40:33.17 Source: Rebuild Index Executing query "ALTER INDEX [IX_ALDEA_VIEW_ENTITY_ACCESS] ON [dbo]...".: 3% complete End Progress Progress: 2012-02-02 01:40:33.17 Source: Rebuild Index Executing query "USE [emeacore] ".: 3% complete End Progress Progress: 2012-02-02 01:40:33.26 Source: Rebuild Index Executing query "ALTER INDEX [IX_ALDEA_VIEW_HIDDEN] ON [dbo].[ALDEA...".: 3% complete End Progress Progress: 2012-02-02 01:40:33.26 Source: Rebuild Index Executing query "USE [e... The package execution fa... The step failed."

    and i found below error in maintenance plan history

    "Executing the query "ALTER INDEX [IX_REQUEST_FIELD_VALUE_3] ON [dbo].[R..." failed with the following error: "An online operation cannot be performed for index 'IX_REQUEST_FIELD_VALUE_3' because the index contains column 'field_value' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The operation must be performed offline.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

    Please help.thanks

  • There is not much information in the job history.

    Each maintenance plan will save the output in a text file which is usually located in the LOG directory of your MSSQL install directory. Click on the 'Reporting and Logging' in your maintenance plan and find the actual directory for the log file.

    The output file will contain more information regarding the error. Give us the actual output.

    If you see error 2725 then the reason is as follows.

    You can not do an ONLINE index rebuild if the index contains a column of type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml. For non-clustered index the column could be an include column of the index, for clustered index it could be any column of the table.

    http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/10a8c8a2-26b5-492c-a02f-1d0eafb76b2f

    Blog
    http://saveadba.blogspot.com/

  • I have checked the log i found the below information.I cound not see any error no 2725.Please see the below information and please help me.

    "

    Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.2531

    Report was generated on "M0".

    Maintenance Plan: Rebulit index for emeacore

    Duration: 00:03:05

    Status: Warning: One or more tasks failed.

    Details:

    Rebuild Index (M0)

    Rebuild index on Local server connection

    Databases: eme

    Object: Table

    Tables/Views: All

    Task start: 2012-02-02T02:58:17.

    Task end: 2012-02-02T03:01:13.

    Failed:(-1073548784) Executing the query "ALTER INDEX [IX_REQUEST_FIELD_VALUE_3] ON [dbo].[R..." failed with the following error: "An online operation cannot be performed for index 'IX_REQUEST_FIELD_VALUE_3' because the index contains column 'field_value' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The operation must be performed offline.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Command:USE [emeacore]

    GO

    ALTER INDEX [IX_ADDRESS_BOOK] ON [dbo].[ADDRESS_BOOK] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ADDRESS_BOOK] ON [dbo].[ADDRESS_BOOK] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ADMSDMAffiliatedCusts] ON [dbo].[ADMSDMAffiliatedCusts] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_PASSWORD_HISTORY] ON [dbo].[ALDEA_PASSWORD_HISTORY] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_USER] ON [dbo].[ALDEA_USER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_USER_1] ON [dbo].[ALDEA_USER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_USER_2] ON [dbo].[ALDEA_USER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_USER_3] ON [dbo].[ALDEA_USER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ALDEA_USER] ON [dbo].[ALDEA_USER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_VIEW] ON [dbo].[ALDEA_VIEW] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_VIEW_ENTITY_ACCESS] ON [dbo].[ALDEA_VIEW_ENTITY_ACCESS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ALDEA_VIEW_HIDDEN] ON [dbo].[ALDEA_VIEW_HIDDEN] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_APPLICATION] ON [dbo].[APPLICATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_APPLICATION_1] ON [dbo].[APPLICATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_APPLICATION_CHANGE] ON [dbo].[APPLICATION_CHANGE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_APPLICATION_RELEASE] ON [dbo].[APPLICATION_RELEASE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_APPROVAL_CHAIN_1] ON [dbo].[APPROVAL_CHAIN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_COMPONENT_FIELD_VALUE] ON [dbo].[ARCHIVE_COMPONENT_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_1] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_2] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_3] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_4] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_5] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_6] ON [dbo].[ARCHIVE_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_COMPONENT] ON [dbo].[ARCHIVE_REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_COMPONENT_1] ON [dbo].[ARCHIVE_REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_COMPONENT_2] ON [dbo].[ARCHIVE_REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_COMPONENT_3] ON [dbo].[ARCHIVE_REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_DEFECT] ON [dbo].[ARCHIVE_REQUEST_DEFECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_DEFECT_1] ON [dbo].[ARCHIVE_REQUEST_DEFECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_FIELD_VALUE] ON [dbo].[ARCHIVE_REQUEST_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_STATUS_HISTORY] ON [dbo].[ARCHIVE_REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_STATUS_HISTORY_2] ON [dbo].[ARCHIVE_REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARCHIVE_REQUEST_STATUS_HISTORY_3] ON [dbo].[ARCHIVE_REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_CLIENT] ON [dbo].[ARIES_CLIENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_FIELD] ON [dbo].[ARIES_FIELD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_FIELD] ON [dbo].[ARIES_FIELD] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_ORGANIZATION] ON [dbo].[ARIES_ORGANIZATION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_ORGANIZATION_FIELD] ON [dbo].[ARIES_ORGANIZATION_FIELD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_ORGANIZATION_QUESTION] ON [dbo].[ARIES_ORGANIZATION_QUESTION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_PERSON] ON [dbo].[ARIES_PERSON] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_PERSON_1] ON [dbo].[ARIES_PERSON] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_QUESTION] ON [dbo].[ARIES_QUESTION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_REQUEST] ON [dbo].[ARIES_REQUEST] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_REQUEST_CONTEXT] ON [dbo].[ARIES_REQUEST_CONTEXT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_REQUEST_FIELD_VALUE_1] ON [dbo].[ARIES_REQUEST_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_REQUEST_SERVICE_INFO] ON [dbo].[ARIES_REQUEST_SERVICE_INFO] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ARIES_SECTION] ON [dbo].[ARIES_SECTION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_SECTION] ON [dbo].[ARIES_SECTION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_SERVICE_LINE] ON [dbo].[ARIES_SERVICE_LINE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ARIES_TASK_CATEGORY] ON [dbo].[ARIES_TASK_CATEGORY] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_Billing_month] ON [dbo].[Billing_month] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_COMMIT_CHANGE_REASON] ON [dbo].[COMMIT_CHANGE_REASON] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_CommonProcess] ON [dbo].[CommonProcess] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMP_DELIVERY_AREA] ON [dbo].[COMP_DELIVERY_AREA] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMP_DELIVERY_AREA_1] ON [dbo].[COMP_DELIVERY_AREA] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMP_DELIVERY_AREA_2] ON [dbo].[COMP_DELIVERY_AREA] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_COMP_DELIVERY_AREA] ON [dbo].[COMP_DELIVERY_AREA] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_CHANGE_HISTORY] ON [dbo].[COMPONENT_CHANGE_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_FIELD_VALUE] ON [dbo].[COMPONENT_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_FIELD_VALUE_FIELD] ON [dbo].[COMPONENT_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_FIELD_VALUE_HISTORY] ON [dbo].[COMPONENT_FIELD_VALUE_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_MAIL_HISTORY] ON [dbo].[COMPONENT_MAIL_HISTORY] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_STATUS] ON [dbo].[COMPONENT_STATUS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_COMPONENT_STATUS] ON [dbo].[COMPONENT_STATUS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_STATUS_HISTORY] ON [dbo].[COMPONENT_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_COMPONENT_STATUS_HISTORY_1] ON [dbo].[COMPONENT_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_CONTAINER_DOCUMENT] ON [dbo].[CONTAINER_DOCUMENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_COST_CENTER_SUPPLIER_1] ON [dbo].[COST_CENTER_SUPPLIER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_CUSTOMER] ON [dbo].[CUSTOMER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_CUSTOMER] ON [dbo].[CUSTOMER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_CUSTOMER_ORGANIZATION] ON [dbo].[CUSTOMER_ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DEFECT_SEVERITY] ON [dbo].[DEFECT_SEVERITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_DEFECT_SEVERITY] ON [dbo].[DEFECT_SEVERITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DEFECT_TYPE] ON [dbo].[DEFECT_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_DEFECT_TYPE] ON [dbo].[DEFECT_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_1] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_2] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_3] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_4] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_5] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_6] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_7] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_8] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_DOCUMENT] ON [dbo].[DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [DOCUMENT_ARCHIVE22] ON [dbo].[DOCUMENT_ARCHIVE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_DOCUMENT_ARCHIVE] ON [dbo].[DOCUMENT_ARCHIVE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_CATEGORY] ON [dbo].[DOCUMENT_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_CATEGORY_1] ON [dbo].[DOCUMENT_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_CATEGORY_2] ON [dbo].[DOCUMENT_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_DOCUMENT_CATEGORY] ON [dbo].[DOCUMENT_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_DOCUMENT_DATA_1] ON [dbo].[DOCUMENT_DATA] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_DOCUMENT_DATA_TEMP] ON [dbo].[DOCUMENT_DATA_TEMP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_EDS_ACCOUNT] ON [dbo].[EDS_ACCOUNT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_EDS_PROGRAMME] ON [dbo].[EDS_PROGRAMME] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_EDSAccountAffiliatedCusts] ON [dbo].[EDSAccountAffiliatedCusts] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_ACCESS] ON [dbo].[ENTITY_ACCESS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_ACCESS_1] ON [dbo].[ENTITY_ACCESS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_ACCESS_2] ON [dbo].[ENTITY_ACCESS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_ACCESS_3] ON [dbo].[ENTITY_ACCESS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_CATEGORY] ON [dbo].[ENTITY_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_CATEGORY_1] ON [dbo].[ENTITY_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_CATEGORY_2] ON [dbo].[ENTITY_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_LINK] ON [dbo].[ENTITY_LINK] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_REQUEST_TYPE_EXTENSION] ON [dbo].[ENTITY_REQUEST_TYPE_EXTENSION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_WORK_TYPE] ON [dbo].[ENTITY_WORK_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ENTITY_WORK_TYPE_1] ON [dbo].[ENTITY_WORK_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ESTIMATES] ON [dbo].[ESTIMATES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_EXPORT_COMPONENT_FIELDS] ON [dbo].[EXPORT_COMPONENT_FIELDS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_EXPORT_REQUEST_FIELDS] ON [dbo].[EXPORT_REQUEST_FIELDS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_FIELD] ON [dbo].[FIELD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_FIELD] ON [dbo].[FIELD] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_GROUP_LINK] ON [dbo].[GROUP_LINK] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_GroupMgr] ON [dbo].[GroupMgr] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_GroupMgrAffiliatedSuppliers] ON [dbo].[GroupMgrAffiliatedSuppliers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IndustryUnit] ON [dbo].[IndustryUnit] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_ALARM] ON [dbo].[IO_ALARM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_CONTACT_EVENT] ON [dbo].[IO_CONTACT_EVENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_FIELD_MAPPING] ON [dbo].[IO_FIELD_MAPPING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_FIELD_VALUE] ON [dbo].[IO_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_MAPPING_SET] ON [dbo].[IO_MAPPING_SET] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_NOTIFICATION] ON [dbo].[IO_NOTIFICATION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_NOTIFICATION_CONTACT] ON [dbo].[IO_NOTIFICATION_CONTACT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_PARTNER] ON [dbo].[IO_PARTNER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_IO_PARTNER_CONTACT] ON [dbo].[IO_PARTNER_CONTACT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_PARTNER_CONTACT] ON [dbo].[IO_PARTNER_CONTACT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_PARTNER_DOCUMENT] ON [dbo].[IO_PARTNER_DOCUMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_PARTNER_LINK] ON [dbo].[IO_PARTNER_LINK] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_PARTNER_REQUEST] ON [dbo].[IO_PARTNER_REQUEST] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_REQUEST] ON [dbo].[IO_REQUEST] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_TRANSACTION_ALARM] ON [dbo].[IO_TRANSACTION_ALARM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_IO_XML_ELEMENT] ON [dbo].[IO_XML_ELEMENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_LIST_OF_VALUES] ON [dbo].[LIST_OF_VALUES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_LIST_OF_VALUES] ON [dbo].[LIST_OF_VALUES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_NOTE] ON [dbo]. REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_OBComments] ON [dbo].[OBComments] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_1] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_2] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_3] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_4] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_5] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_6] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ONLINE_STATUS_RPTS] ON [dbo].[ONLINE_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_milestones_1] ON [dbo].[ONLINE_STATUS_RPTS_MILESTONES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_milestones_2] ON [dbo].[ONLINE_STATUS_RPTS_MILESTONES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_milestones_3] ON [dbo].[ONLINE_STATUS_RPTS_MILESTONES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_online_status_rpts_milestones_4] ON [dbo].[ONLINE_STATUS_RPTS_MILESTONES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ONLINE_STATUS_RPTS_MILESTONES] ON [dbo].[ONLINE_STATUS_RPTS_MILESTONES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION] ON [dbo].[ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_1] ON [dbo].[ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_2] ON [dbo].[ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ORGANIZATION] ON [dbo].[ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_APPLICATION] ON [dbo].[ORGANIZATION_APPLICATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_DELIVERY] ON [dbo].[ORGANIZATION_DELIVERY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_ESCALATION_MILESTONE] ON [dbo].[ORGANIZATION_ESCALATION_MILESTONE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_PRIORITY] ON [dbo].[ORGANIZATION_PRIORITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ORGANIZATION_SLC_PHASE] ON [dbo].[ORGANIZATION_SLC_PHASE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_ZONE] ON [dbo].[ORGANIZATION_ZONE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_ORGANIZATION_ZONE_1] ON [dbo].[ORGANIZATION_ZONE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PENDING_ENTITY_CATEGORY] ON [dbo].[PENDING_ENTITY_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PENDING_ENTITY_CATEGORY_1] ON [dbo].[PENDING_ENTITY_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PENDING_ENTITY_CATEGORY_2] ON [dbo].[PENDING_ENTITY_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PENDING_ENTITY_WORK_TYPE] ON [dbo].[PENDING_ENTITY_WORK_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PENDING_ENTITY_WORK_TYPE_1] ON [dbo].[PENDING_ENTITY_WORK_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_Priority] ON [dbo].[Priority] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_PriorityAffiliatedCustomers] ON [dbo].[PriorityAffiliatedCustomers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_Programme] ON [dbo].[Programme] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ProgrammeAffiliatedCustomer] ON [dbo].[ProgrammeAffiliatedCustomers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ProgrammeMgr] ON [dbo].[ProgrammeMgr] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PROJECT] ON [dbo].[PROJECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_PROJECT_1] ON [dbo].[PROJECT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_PROJECT] ON [dbo].[PROJECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_RELEASE] ON [dbo].[RELEASE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_RELEASE] ON [dbo].[RELEASE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_1] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_10] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_11] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_12] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_13] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_14] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_15] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_16] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_17] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_2] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_3] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_4] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_5] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_6] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_7] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_8] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_9] ON [dbo].[REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_CHANGE_HISTORY] ON [dbo].[REQUEST_CHANGE_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_1] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_2] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_3] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_4] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_6] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_7] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_COMPONENT_8] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_COMPONENT] ON [dbo].[REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_DEFECT] ON [dbo].[REQUEST_DEFECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_DEFECT] ON [dbo].[REQUEST_DEFECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_FIELD_VALUE_1] ON [dbo].[REQUEST_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_FIELD_VALUE_2] ON [dbo].[REQUEST_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_FIELD_VALUE_3] ON [dbo].[REQUEST_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_FIELD_VALUE_FIELD] ON [dbo].[REQUEST_FIELD_VALUE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_FIELD_VALUE_HISTORY] ON [dbo].[REQUEST_FIELD_VALUE_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_MAIL_HISTORY] ON [dbo].[REQUEST_MAIL_HISTORY] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_NOTES] ON [dbo].[REQUEST_NOTES] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_PRIORITY] ON [dbo].[REQUEST_PRIORITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_PRIORITY_1] ON [dbo].[REQUEST_PRIORITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_PRIORITY] ON [dbo].[REQUEST_PRIORITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_RELATIONSHIP] ON [dbo].[REQUEST_RELATIONSHIP] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_RELATIONSHIP_1] ON [dbo].[REQUEST_RELATIONSHIP] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_RELATIONSHIP] ON [dbo].[REQUEST_RELATIONSHIP] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_STATUS] ON [dbo].[REQUEST_STATUS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_STATUS] ON [dbo].[REQUEST_STATUS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_STATUS_HISTORY] ON [dbo].[REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_STATUS_HISTORY_1] ON [dbo].[REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_STATUS_HISTORY_2] ON [dbo].[REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_STATUS_HISTORY_3] ON [dbo].[REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_STATUS_HISTORY_4] ON [dbo].[REQUEST_STATUS_HISTORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_REQUEST_TYPE] ON [dbo].[REQUEST_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_TYPE] ON [dbo].[REQUEST_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_REQUEST_TYPE_EXTENSION] ON [dbo].[REQUEST_TYPE_EXTENSION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_AUTH_UNBILL_HRS] ON [dbo].[SAP_AUTH_UNBILL_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_AUTH_UNBILL_HRS_1] ON [dbo].[SAP_AUTH_UNBILL_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_AUTH_UNBILL_HRS] ON [dbo].[SAP_AUTH_UNBILL_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_1] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_2] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_3] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_4] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_5] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_6] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_authorised_hrs_7] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_AUTHORISED_HRS] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_AUTHORISED_HRS_1] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_AUTHORISED_HRS] ON [dbo].[SAP_AUTHORISED_HRS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_EMPLOYEES] ON [dbo].[SAP_EMPLOYEES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_Project_Codes] ON [dbo].[SAP_Project_Codes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_RATES] ON [dbo].[SAP_RATES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_RESOURCES] ON [dbo].[SAP_RESOURCES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_RESOURCES] ON [dbo].[SAP_RESOURCES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_Revenue] ON [dbo].[SAP_Revenue] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_Revenue_1] ON [dbo].[SAP_Revenue] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_Sap_revenue_errors_2] ON [dbo].[SAP_REVENUE_ERRORS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_Errors] ON [dbo].[SAP_UNAUTH_ERRORS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_UPLOAD_AUTH] ON [dbo].[SAP_UPLOAD_AUTH] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_UPLOAD] ON [dbo].[SAP_UPLOAD_UNAUTH] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_wp_auth_hrs_ed_1] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_wp_auth_hrs_ed_2] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_wp_auth_hrs_ed_3] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_Authorised_Hours] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_WP_AUTH_HRS_EDS] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_WP_AUTH_HRS_EDS_1] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SAP_WP_AUTH_HRS_EDS] ON [dbo].[SAP_WP_AUTH_HRS_EDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_sap_wp_revenue_1] ON [dbo].[SAP_WP_REVENUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_WP_REVENUE] ON [dbo].[SAP_WP_REVENUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SAP_WP_REVENUE_1] ON [dbo].[SAP_WP_REVENUE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SLC_PHASE_1] ON [dbo].[SLC_PHASE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SLC_PHASE] ON [dbo].[SLC_PHASE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SSO_USER] ON [dbo].[SSO_USER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_StatusControl] ON [dbo].[StatusControl] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_SUPPLIER] ON [dbo].[SUPPLIER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SUPPORTING_ORGANIZATIONS] ON [dbo].[SUPPORTING_ORGANIZATIONS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_SUPPORTING_ORGANIZATIONS_1] ON [dbo].[SUPPORTING_ORGANIZATIONS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_TABLE_REGISTRY] ON [dbo].[TABLE_REGISTRY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TABLE_REGISTRY] ON [dbo].[TABLE_REGISTRY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ADDRESS_BOOK] ON [dbo].[TEMP_ADDRESS_BOOK] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ALDEA_USER] ON [dbo].[TEMP_ALDEA_USER] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_CLIENT] ON [dbo].[TEMP_ARIES_CLIENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_FIELD] ON [dbo].[TEMP_ARIES_FIELD] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_ORGANIZATION] ON [dbo].[TEMP_ARIES_ORGANIZATION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_QUESTION] ON [dbo].[TEMP_ARIES_QUESTION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_REQUEST] ON [dbo].[TEMP_ARIES_REQUEST] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_SECTION] ON [dbo].[TEMP_ARIES_SECTION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_SERVICE_LINE] ON [dbo].[TEMP_ARIES_SERVICE_LINE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ARIES_TASK_CATEGORY] ON [dbo].[TEMP_ARIES_TASK_CATEGORY] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_FIELD] ON [dbo].[TEMP_FIELD] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_NOTE] ON [dbo].[TEMP_NOTE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ORGANIZATION] ON [dbo].[TEMP_ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_PROJECT] ON [dbo].[TEMP_PROJECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_REQUEST_COMPONENT] ON [dbo].[TEMP_REQUEST_COMPONENT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_REQUEST_DEFECT] ON [dbo].[TEMP_REQUEST_DEFECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_TABLE_REGISTRY] ON [dbo].[TEMP_TABLE_REGISTRY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_USER_FUNCTION] ON [dbo].[TEMP_USER_FUNCTION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_USER_ROLE] ON [dbo].[TEMP_USER_ROLE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ZONE] ON [dbo].[TEMP_ZONE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_TEMP_ZONE_LINK] ON [dbo].[TEMP_ZONE_LINK] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_TTPARequestAudit_3] ON [dbo].[TTPARequestAudit] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_TTPARequestAudit_4] ON [dbo].[TTPARequestAudit] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_USER_ACCOUNT_CONVERSION] ON [dbo].[USER_ACCOUNT_CONVERSION] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_AFFILIATED_ORGANIZATIONS] ON [dbo].[USER_AFFILIATED_ORGANIZATIONS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_AFFILIATED_ORGANIZATIONS_1] ON [dbo].[USER_AFFILIATED_ORGANIZATIONS] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_FUNCTION_1] ON [dbo].[USER_FUNCTION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_USER_FUNCTION] ON [dbo].[USER_FUNCTION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_USER_GROUP] ON [dbo].[USER_GROUP] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_GROUP_CATEGORY] ON [dbo].[USER_GROUP_CATEGORY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_MRU] ON [dbo].[USER_MRU] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_ORGANIZATION_1] ON [dbo].[USER_ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_ORGANIZATION_2] ON [dbo].[USER_ORGANIZATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_PROJECT] ON [dbo].[USER_PROJECT] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_ROLE_1] ON [dbo].[USER_ROLE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_USER_ROLE] ON [dbo].[USER_ROLE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_ROLE_AUTHORITY] ON [dbo].[USER_ROLE_AUTHORITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_ROLE_AUTHORITY_1] ON [dbo].[USER_ROLE_AUTHORITY] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_TYPE_1] ON [dbo].[USER_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_USER_TYPE] ON [dbo].[USER_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_USER_VACATION_1] ON [dbo].[USER_VACATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_USER_VACATION] ON [dbo].[USER_VACATION] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_WBSCommonProcess] ON [dbo].[WBSCommonProcess] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_WBSTypes] ON [dbo].[WBSTypes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_apps_1] ON [dbo].[WORK_PACKET_APPS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_apps_3] ON [dbo].[WORK_PACKET_APPS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_apps_5] ON [dbo].[WORK_PACKET_APPS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_apps_6] ON [dbo].[WORK_PACKET_APPS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [IX_WORK_PACKET_APPS] ON [dbo].[WORK_PACKET_APPS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_WORK_PACKET_APPS] ON [dbo].[WORK_PACKET_APPS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_status_1] ON [dbo].[WORK_PACKET_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_status_2] ON [dbo].[WORK_PACKET_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packet_status_3] ON [dbo].[WORK_PACKET_STATUS_RPTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packets_1] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packets_2] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packets_3] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packets_4] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packets_5] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [ind_work_packets_6] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_WORK_PACKETS] ON [dbo].[WORK_PACKETS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_WORK_TYPE] ON [dbo].[WORK_TYPE] REBUILD PARTITION = ALL WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ZONE] ON [dbo].[ZONE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    GO

    USE [emeacore]

    GO

    ALTER INDEX [PK_ZONE_LINK] ON [dbo].[ZONE_LINK] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = ON, SORT_IN_TEMPDB = OFF )

    "

    can any help me plz

  • As the error below clearly statest that you are trying to perform Online rebuild operation on an index that contains data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type, therefore you will not be able to rebuild this index online, you would need to exclude these indexes from online rebuild operation and try to rebuild these indexes Offline or just reorganize the indexes in question

    An online operation cannot be performed for index 'IX_REQUEST_FIELD_VALUE_3' because the index contains column 'field_value' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type.

  • As I expected you can not rebuild the particular index in ONLINE mode because of the column 'field_value'.

    Check the number of pages in the index and if it is not too large then I suggest that you remove that table from the index rebuild maintenance step. Add a new step to either reorganize it or rebuild it offline.

    To find the number of pages, right click on the index name and go to 'Fragmentation' and check the number of PAGES'.

    Blog
    http://saveadba.blogspot.com/

  • ok check this link below

    http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/[/url]

    :w00t:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply