Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Rebuild index task/job fails every time... Expand / Collapse
Author
Message
Posted Monday, July 04, 2011 2:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 10:43 AM
Points: 389, Visits: 305
We are using SQL Server 2008 Enterprise 64bit.
And we have made standard database optimalisation jobs via the maintenance plans.
The rebuild index task will run weekly, but is failed the last 3 weeks.

When I check the history of the job, I encounter following error after 9minutes:

Executing query "ALTER INDEX [PK_AboProductType] ON [dbo].[AboProdu...".: 2% complete End Prog... The package execution fa... The step failed.

But this will not give me the information I need to correct this problem!

When i want to run the standard report: Index usage statistics, I get following error:

Error:

Incorrect syntax near '('.


What can I do to get the job running clearly again?
I don't know where to start
Post #1135764
Posted Monday, July 04, 2011 2:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:25 PM
Points: 1,153, Visits: 4,603
Rhox (7/4/2011)
We are using SQL Server 2008 Enterprise 64bit.
And we have made standard database optimalisation jobs via the maintenance plans.
The rebuild index task will run weekly, but is failed the last 3 weeks.

When I check the history of the job, I encounter following error after 9minutes:

Executing query "ALTER INDEX [PK_AboProductType] ON [dbo].[AboProdu...".: 2% complete End Prog... The package execution fa... The step failed.

But this will not give me the information I need to correct this problem!

When i want to run the standard report: Index usage statistics, I get following error:

Error:

Incorrect syntax near '('.


What can I do to get the job running clearly again?
I don't know where to start


Can you show me the script?

Give me the full error from job or maintenance plan.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1135767
Posted Monday, July 04, 2011 2:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 10:43 AM
Points: 389, Visits: 305
Script: (T-SQL from the mainenance plan task)
USE [A105_P]
GO
ALTER INDEX [PK__NewBoSecurityCheck] ON [dbo].[_NewBoSecurityCheck] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboActivationCode] ON [dbo].[AboActivationCode] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboActive] ON [dbo].[AboActive] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_AboCondition] ON [dbo].[AboCondition] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboEmailReminder] ON [dbo].[AboEmailReminder] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboEmailReminderSent] ON [dbo].[AboEmailReminderSent] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboOrder] ON [dbo].[AboOrder] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboOrderSAP] ON [dbo].[AboOrderSAP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Abo] ON [dbo].[AboProduct] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboProductCollection] ON [dbo].[AboProductCollection] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboProductEmail] ON [dbo].[AboProductEmail] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboProductType] ON [dbo].[AboProductType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboRegion] ON [dbo].[AboRegion] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_AboSAPInfo_1] ON [dbo].[AboSAPInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ActionLog_ContentId] ON [dbo].[ActionLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ActionLog_ContentSid] ON [dbo].[ActionLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ActionLog_Timestamp] ON [dbo].[ActionLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ActionLog_visitorguid] ON [dbo].[ActionLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__ActionLog__57C993F9] ON [dbo].[ActionLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Advertisements] ON [dbo].[Advertisements] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Agendalinks] ON [dbo].[Agendalinks] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ArtGraphMap] ON [dbo].[ArtGraphMap] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ARTICLE_EXTRA_SLIDESHOW] ON [dbo].[ARTICLE_EXTRA_SLIDESHOW] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__ArticleContentTy__20CE64CA] ON [dbo].[ArticleContentType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ArticlesToday] ON [dbo].[ArticlesToday] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Blog] ON [dbo].[Blog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_BlogCategory_blogId] ON [dbo].[BlogCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_BlogCategory] ON [dbo].[BlogCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_BlogCategory_News_All] ON [dbo].[BlogCategory_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_BlogCategory_News_ArticleId] ON [dbo].[BlogCategory_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_BlogCategory_News_blogCategory] ON [dbo].[BlogCategory_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_BlogCategory_News] ON [dbo].[BlogCategory_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__brailleArtikelWe__086B34A6] ON [dbo].[brailleArtikelWeek] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_BreakingNews] ON [dbo].[BreakingNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Calenders] ON [dbo].[Calendars] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Categories] ON [dbo].[Calendars_Categories] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Calendars_Items] ON [dbo].[Calendars_Items] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Calendars_Items] ON [dbo].[Calendars_Items] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Calendars_Items_Links] ON [dbo].[Calendars_Items_Links] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_City] ON [dbo].[City] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_comMailing] ON [dbo].[comMailing] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_comTask] ON [dbo].[comTask] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Contributors] ON [dbo].[Contributors] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Countries] ON [dbo].[Countries] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Approved] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_AuthorEmail] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Debate_CreatedOn] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_IsTalkback] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Ix_Rlevel] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RootId] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RootID_Approved_rLevel_CreatedOn_ParentId] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RootId_Level_Approved] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RootId_PaperCode] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserId] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Workflow] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Debate] ON [dbo].[Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Debate_Deletes] ON [dbo].[Debate_Deletes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Debate_Keywords] ON [dbo].[Debate_Keywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Debate_Keywords] ON [dbo].[Debate_Keywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Debate_ModerationStatus] ON [dbo].[Debate_ModerationStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Debate_User_Email] ON [dbo].[Debate_User] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserId] ON [dbo].[Debate_User] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Debate_User] ON [dbo].[Debate_User] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DebateFlags] ON [dbo].[DebateFlags] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DebateFlagStatus_1] ON [dbo].[DebateFlagStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Ix_DossierId] ON [dbo].[DossierKeywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DossierKeywords_DossierId] ON [dbo].[DossierKeywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DossierKeywords_Keyword] ON [dbo].[DossierKeywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Ix_Keyword] ON [dbo].[DossierKeywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_BreadCrumb] ON [dbo].[DSO_BreadCrumb] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_Cim] ON [dbo].[DSO_Cim] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FeedChannels] ON [dbo].[DSO_Feed] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FeedCategory] ON [dbo].[DSO_FeedCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FeedCategoryOrder] ON [dbo].[DSO_FeedCategoryOrder] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FeedGroups] ON [dbo].[DSO_FeedGroup] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO_FeedItem_Guid] ON [dbo].[DSO_FeedItem] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_FeedId] ON [dbo].[DSO_FeedItem] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FeedItems] ON [dbo].[DSO_FeedItem] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FeedsByCategory] ON [dbo].[DSO_FeedsByCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_HelpTopics] ON [dbo].[DSO_HelpTopics] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_InfoTopics] ON [dbo].[DSO_InfoTopics] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_PromoPipes] ON [dbo].[DSO_PromoPipes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO_TrustedIp] ON [dbo].[DSO_TrustedIp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_ArcticleFrontMobile] ON [dbo].[DSO35_ArcticleFrontMobile] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_Counters_ArticleId] ON [dbo].[DSO35_News_Counters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_Counters_MostRead] ON [dbo].[DSO35_News_Counters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_Counters_MostVoted] ON [dbo].[DSO35_News_Counters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_Counters_PaperCode] ON [dbo].[DSO35_News_Counters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_News_Counters] ON [dbo].[DSO35_News_Counters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_Counters_Tmp_ArticleId] ON [dbo].[DSO35_News_Counters_Tmp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_News_Counters_Tmp] ON [dbo].[DSO35_News_Counters_Tmp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_DayCounters_MostReadByDay] ON [dbo].[DSO35_News_DayCounters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_DayCounters_ReadDate] ON [dbo].[DSO35_News_DayCounters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_News_DayCounters] ON [dbo].[DSO35_News_DayCounters] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_News_GMaps] ON [dbo].[DSO35_News_GMaps] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_Teaser] ON [dbo].[DSO35_Teaser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_Visitor] ON [dbo].[DSO35_Visitor] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_VisitorVote_ArticleId] ON [dbo].[DSO35_VisitorVote] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DSO35_VisitorVote_VisitorId] ON [dbo].[DSO35_VisitorVote] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DSO35_VisitorVote] ON [dbo].[DSO35_VisitorVote] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_DsoNewsOpen] ON [dbo].[DsoNewsOpen] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Edition_Province_Cities] ON [dbo].[Edition_Province_Cities] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Enquete] ON [dbo].[Enquete] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_EnqueteAnswer] ON [dbo].[EnqueteAnswer] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EnqueteAnswer] ON [dbo].[EnqueteAnswer] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ExterneLinks_ArticleID] ON [dbo].[ExterneLinks] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ExterneLinks_ExternalId] ON [dbo].[ExterneLinks] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ExterneLinks] ON [dbo].[ExterneLinks] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_AGENDA_EVENTS] ON [dbo].[EXTRA_AGENDA_EVENTS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_AGENDA_ITEM] ON [dbo].[EXTRA_AGENDA_ITEM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_AGENDA_SUBCAT] ON [dbo].[EXTRA_AGENDA_SUBCAT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_extra_boekspaarpromo] ON [dbo].[extra_boekspaarpromo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_extra_centra] ON [dbo].[extra_centra] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FAQ_CATEGORIE] ON [dbo].[EXTRA_FAQ_CATEGORIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FAQ_VRAGEN] ON [dbo].[EXTRA_FAQ_VRAGEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_2002] ON [dbo].[EXTRA_FESTIVAL_2002] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_2003] ON [dbo].[EXTRA_FESTIVAL_2003] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_2004] ON [dbo].[EXTRA_FESTIVAL_2004] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_2005] ON [dbo].[EXTRA_FESTIVAL_2005] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_BANDS] ON [dbo].[EXTRA_FESTIVAL_BANDS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_INFO] ON [dbo].[EXTRA_FESTIVAL_INFO] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_FESTIVAL_PODIA] ON [dbo].[EXTRA_FESTIVAL_PODIA] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Extra_Financieel_Functie] ON [dbo].[Extra_Financieel_Functie] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Extra_Financieel_Mandaat] ON [dbo].[Extra_Financieel_Mandaat] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Extra_Financieel_Persoon] ON [dbo].[Extra_Financieel_Persoon] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_GEMEENTE] ON [dbo].[EXTRA_GEMEENTE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_JAAROVERZICHT_ARTIKELS] ON [dbo].[EXTRA_JAAROVERZICHT_ARTIKELS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_JAAROVERZICHT_ITEM_RUBRIEK] ON [dbo].[EXTRA_JAAROVERZICHT_ITEM_RUBRIEK] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_JAAROVERZICHT_ITEMS] ON [dbo].[EXTRA_JAAROVERZICHT_ITEMS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__EXTRA_JAAROVERZI__33BFA6FF] ON [dbo].[EXTRA_JAAROVERZICHT_RUBRIEKEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_LANDEN] ON [dbo].[EXTRA_LANDEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_LINK_CATEGORIE] ON [dbo].[EXTRA_LINK_CATEGORIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_LINKS] ON [dbo].[EXTRA_LINKS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_MUNTEN] ON [dbo].[EXTRA_MUNTEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_ORGANISATIES] ON [dbo].[EXTRA_ORGANISATIES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_extra_parelvissers] ON [dbo].[extra_parelvissers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Extra_ParlementsRapport_partij] ON [dbo].[Extra_ParlementsRapport] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Extra_ParlementsRapport] ON [dbo].[Extra_ParlementsRapport] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Extra_ParlementsRapport_Partijen] ON [dbo].[Extra_ParlementsRapport_Partijen] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_PERSONEN] ON [dbo].[EXTRA_PERSONEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_PERSONEN_CATEGORIE] ON [dbo].[EXTRA_PERSONEN_CATEGORIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_PERSONEN_DETAILS] ON [dbo].[EXTRA_PERSONEN_DETAILS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_PERSONEN_FUNCTIES] ON [dbo].[EXTRA_PERSONEN_FUNCTIES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_PERSONEN_SUBCAT] ON [dbo].[EXTRA_PERSONEN_SUBCAT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_PROVINCIES] ON [dbo].[EXTRA_PROVINCIES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Extra_Rapport_Regering_partijid] ON [dbo].[Extra_Rapport_Regering] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Extra_Rapport_Regering] ON [dbo].[Extra_Rapport_Regering] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_REGERINGSVORMEN] ON [dbo].[EXTRA_REGERINGSVORMEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Extra_Slides_SlideShow_Id] ON [dbo].[EXTRA_SLIDES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_SLIDES] ON [dbo].[EXTRA_SLIDES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_SLIDESHOW] ON [dbo].[EXTRA_SLIDESHOW] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__EXTRA_SLIDESHOW___43F60EC8] ON [dbo].[EXTRA_SLIDESHOW_AUTEUR] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_SLIDESHOW_TYPE] ON [dbo].[EXTRA_SLIDESHOW_TYPE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_STAATSVORMEN] ON [dbo].[EXTRA_STAATSVORMEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_extra_typecentra] ON [dbo].[extra_typecentra] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_VERKOOPPUNTEN] ON [dbo].[EXTRA_VERKOOPPUNTEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_extra_wedstrijd] ON [dbo].[extra_wedstrijd] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_EXTRA_WERELDDELEN] ON [dbo].[EXTRA_WERELDDELEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_extra_wieishet] ON [dbo].[extra_wieishet] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ExtraArticles] ON [dbo].[ExtraArticles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ExtraArticles_ArticleID] ON [dbo].[ExtraArticles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ExtraArticles_ArticleID2] ON [dbo].[ExtraArticles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ExtraArticles_ExternalId] ON [dbo].[ExtraArticles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ExtraArticles] ON [dbo].[ExtraArticles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ExtraPages] ON [dbo].[ExtraPages] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [UX_ExtraPages_Redirect] ON [dbo].[ExtraPages] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_FacebookAdmins_FbUserId] ON [dbo].[FacebookAdmins] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FacebookAdmins] ON [dbo].[FacebookAdmins] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_FacebookApplications_PaperCode] ON [dbo].[FacebookApplications] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FacebookApplications] ON [dbo].[FacebookApplications] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FacebookApplications_FacebookAdmins_1] ON [dbo].[FacebookApplications_FacebookAdmins] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_FacebookFanPagePosts_ArticleId] ON [dbo].[FacebookFanPagePosts] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FacebookFanPagePosts] ON [dbo].[FacebookFanPagePosts] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_FacebookFanPages_PageType] ON [dbo].[FacebookFanPages] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FacebookFanPages] ON [dbo].[FacebookFanPages] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_FacebookFanPages_FacebookAdmins_1] ON [dbo].[FacebookFanPages_FacebookAdmins] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_GenericTemplate] ON [dbo].[GenericTemplate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__GraphMap__57FD0775] ON [dbo].[GraphMap] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__GroupMnt__2F869875] ON [dbo].[GroupMnt] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__GroupMnt_Module__353F71CB] ON [dbo].[GroupMnt_Module] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__GroupMnt_UserMnt__316EE0E7] ON [dbo].[GroupMnt_UserMnt] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MuurKrant] ON [dbo].[GuestBook] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_DateCreated] ON [dbo].[HetEiland] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Email] ON [dbo].[HetEiland] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboActive] ON [dbo].[HNO_AboActive] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboCondition] ON [dbo].[HNO_AboCondition] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboEmailReminder] ON [dbo].[HNO_AboEmailReminder] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboEmailReminderSent] ON [dbo].[HNO_AboEmailReminderSent] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboOrder] ON [dbo].[HNO_AboOrder] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Abo] ON [dbo].[HNO_AboProduct] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_HNO_AboProductEmail] ON [dbo].[HNO_AboProductEmail] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboProductEmail] ON [dbo].[HNO_AboProductEmail] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboProductType] ON [dbo].[HNO_AboProductType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_AboRegion] ON [dbo].[HNO_AboRegion] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Buttons] ON [dbo].[HNO_Buttons] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Countries] ON [dbo].[HNO_Countries] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Extras] ON [dbo].[HNO_Extras] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Ezine] ON [dbo].[HNO_Ezine] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_EzineSubscription] ON [dbo].[HNO_EzineSubscription] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_FONDSEN_CONTENT] ON [dbo].[HNO_FONDSEN_CONTENT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Game_Answers] ON [dbo].[HNO_Game_Answers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_GAME_MEMBERS] ON [dbo].[HNO_Game_Members] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Games_Poll] ON [dbo].[HNO_Game_Poll] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_GAMES_Questions] ON [dbo].[HNO_Game_Questions] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Game_Results] ON [dbo].[HNO_Game_Results] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Layout] ON [dbo].[HNO_Layout] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Offer_Details] ON [dbo].[HNO_Offer_Details] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Offers] ON [dbo].[HNO_Offers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Orders] ON [dbo].[HNO_Orders] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Pagetypes] ON [dbo].[HNO_Pagetype] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_PromoPipes] ON [dbo].[HNO_PromoPipes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Site] ON [dbo].[HNO_Site] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_HNO_Titles] ON [dbo].[HNO_Titles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PostCode] ON [dbo].[HNO_Verkooppunt] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ImageArticlePath_Temp] ON [dbo].[ImageArticlePath_Temp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Image_FileRef] ON [dbo].[Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Images_ExternalId] ON [dbo].[Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Images_InsertDate] ON [dbo].[Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Images_SizeKb] ON [dbo].[Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Images] ON [dbo].[Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__ImageSet__51A6A64F] ON [dbo].[ImageSet] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__ImageSet_Media__566B5B6C] ON [dbo].[ImageSet_Media] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ImagesM] ON [dbo].[ImagesM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_info_afdelingen] ON [dbo].[info_afdelingen] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_info_redacteurs] ON [dbo].[info_redacteurs] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_info_shift] ON [dbo].[info_shift] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__info_werklijst__679F3DB8] ON [dbo].[info_werklijst] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_internalMessage] ON [dbo].[internalMessage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_IrnServiceGroupPaths] ON [dbo].[IrnServiceGroupPaths] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_IrnServiceGroups] ON [dbo].[IrnServiceGroups] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_IrnServiceRequests] ON [dbo].[IrnServiceRequests] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Kanaal] ON [dbo].[Kanaal] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Kanaal] ON [dbo].[Kanaal] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_LIVE_STAGE] ON [dbo].[LIVE_STAGE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [paper_date] ON [dbo].[MailingLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MailingLog] ON [dbo].[MailingLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MailingLogStatus] ON [dbo].[MailingLogStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_mailingProvinces] ON [dbo].[mailingProvinces] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_StandByProducts] ON [dbo].[Mailings] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Mailings_Subscriptions_UserId] ON [dbo].[Mailings_Subscriptions] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_StandByProducts_Subscriptions] ON [dbo].[Mailings_Subscriptions] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_mailingSubsections] ON [dbo].[mailingSubSections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MaintLog] ON [dbo].[MaintLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MediaType] ON [dbo].[MediaType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_FAQ] ON [dbo].[MEGA_FAQ] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_game_code] ON [dbo].[MEGA_GAME] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME] ON [dbo].[MEGA_GAME] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_BETALING] ON [dbo].[MEGA_GAME_BETALING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_BETALING] ON [dbo].[MEGA_GAME_BETALING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_BETALING_ONLINE] ON [dbo].[MEGA_GAME_BETALING_ONLINE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_CATEGORIE] ON [dbo].[MEGA_GAME_CATEGORIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_FAQ] ON [dbo].[MEGA_GAME_FAQ] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_JOKERS] ON [dbo].[MEGA_GAME_JOKERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_game_id_mega_code] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_naam] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_gameId_deelnemerId_statusId] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Mijnploeg_DeelnemerId] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Mijnploeg_MegaCode] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_MIJNPLOEG] ON [dbo].[MEGA_GAME_MIJNPLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_MIJNPLOEG_LOG] ON [dbo].[MEGA_GAME_MIJNPLOEG_LOG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SCORES] ON [dbo].[MEGA_GAME_MIJNPLOEG_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SCORES_1] ON [dbo].[MEGA_GAME_MIJNPLOEG_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SCORES_PERIODE] ON [dbo].[MEGA_GAME_MIJNPLOEG_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_MIJNPLOEG_SCORES] ON [dbo].[MEGA_GAME_MIJNPLOEG_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SPELERS] ON [dbo].[MEGA_GAME_MIJNPLOEG_SPELERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SPELERS_1] ON [dbo].[MEGA_GAME_MIJNPLOEG_SPELERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SPELERS_2] ON [dbo].[MEGA_GAME_MIJNPLOEG_SPELERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_MIJNPLOEG_SPELERS] ON [dbo].[MEGA_GAME_MIJNPLOEG_SPELERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_MIJNPLOEG_SPELERS_DENORM] ON [dbo].[MEGA_GAME_MIJNPLOEG_SPELERS_DENORM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_PERIODE] ON [dbo].[MEGA_GAME_PERIODE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_PERIODE_1] ON [dbo].[MEGA_GAME_PERIODE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_PERIODE] ON [dbo].[MEGA_GAME_PERIODE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [speeldag] ON [dbo].[MEGA_GAME_PERIODE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_PLOEG] ON [dbo].[MEGA_GAME_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_PLOEG_1] ON [dbo].[MEGA_GAME_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_PLOEG] ON [dbo].[MEGA_GAME_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_POSITIE] ON [dbo].[MEGA_GAME_POSITIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_DEELNEMER_CATEGORIE] ON [dbo].[MEGA_GAME_RANKING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_SPEELDAG] ON [dbo].[MEGA_GAME_SPEELDAG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_SPEELDAG] ON [dbo].[MEGA_GAME_SPEELDAG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_SPELER_FICHE] ON [dbo].[MEGA_GAME_SPELER_FICHE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_ploeg_id_speler_code] ON [dbo].[MEGA_GAME_SPELERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_SPELERS] ON [dbo].[MEGA_GAME_SPELERS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_SPELERS_SCORES] ON [dbo].[MEGA_GAME_SPELERS_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_SPELERS_SCORES_1] ON [dbo].[MEGA_GAME_SPELERS_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_MIJNPLOEG_STATUS] ON [dbo].[MEGA_GAME_STATUS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_naam] ON [dbo].[MEGA_GAME_TEAMCUP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_TEAMCUP] ON [dbo].[MEGA_GAME_TEAMCUP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_TEAMCUP] ON [dbo].[MEGA_GAME_TEAMCUP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_TEAMCUP_SCORES] ON [dbo].[MEGA_GAME_TEAMCUP_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_TEAMCUP_SCORES] ON [dbo].[MEGA_GAME_TEAMCUP_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_TRANSFER] ON [dbo].[MEGA_GAME_TRANSFER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_TRANSFER_1] ON [dbo].[MEGA_GAME_TRANSFER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_TRANSFER_2] ON [dbo].[MEGA_GAME_TRANSFER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_TRASNFER_STATUS] ON [dbo].[MEGA_GAME_TRANSFER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_TRANSFER] ON [dbo].[MEGA_GAME_TRANSFER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_TRANSFER_REGELING] ON [dbo].[MEGA_GAME_TRANSFER_REGELING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_naam] ON [dbo].[MEGA_GAME_VOETBALCUP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_VOETBALCUP] ON [dbo].[MEGA_GAME_VOETBALCUP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_VOETBALCUP] ON [dbo].[MEGA_GAME_VOETBALCUP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_GAME_VOETBALCUP_SCORES] ON [dbo].[MEGA_GAME_VOETBALCUP_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_GAME_VOETBALCUP_SCORES] ON [dbo].[MEGA_GAME_VOETBALCUP_SCORES] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_MEGA_VOETBAL_WEDSTRIJD] ON [dbo].[MEGA_VOETBAL_WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MEGA_VOETBAL_WEDSTRIJD] ON [dbo].[MEGA_VOETBAL_WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MenuItemAttributes] ON [dbo].[MenuItemAttributes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MenuItems] ON [dbo].[MenuItems] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Menus] ON [dbo].[Menus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__MNT_ApplicationA__17E4190E] ON [dbo].[MNT_ApplicationAnnouncement] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__MNT_ApplicationA__15FBD09C] ON [dbo].[MNT_ApplicationAnnouncementType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ModerationStatus] ON [dbo].[ModerationStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Modules] ON [dbo].[Modules] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [UQ_Modules_1__16] ON [dbo].[Modules] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MonthDossier] ON [dbo].[MonthDossier] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [MonthDossierId] ON [dbo].[MonthDossierByArticle] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MonthDossierByArticle] ON [dbo].[MonthDossierByArticle] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MonthDossierByLand] ON [dbo].[MonthDossierByLand] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MonthDossierByOrganisatie] ON [dbo].[MonthDossierByOrganisatie] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MonthDossierByPersoon] ON [dbo].[MonthDossierByPersoon] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSBelgium] ON [dbo].[MSBelgium] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSStationBelgium] ON [dbo].[MSStationBelgium] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSStationWorld] ON [dbo].[MSStationWorld] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSTekst] ON [dbo].[MSTekst] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSWeerBelgium] ON [dbo].[MSWeerBelgium] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSWeerWorld] ON [dbo].[MSWeerWorld] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_MSWorld] ON [dbo].[MSWorld] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NBO_BlogUser] ON [dbo].[NBO_BlogUser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NBO_BlogUSer_News_ArticleId] ON [dbo].[NBO_BlogUSer_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NBO_BlogUSer_News] ON [dbo].[NBO_BlogUSer_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NBOMNT_Modules] ON [dbo].[NBOMNT_Modules] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NBOMNT_ProfileGroups] ON [dbo].[NBOMNT_ProfileGroups] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NBOMNT_UsercontrolProperties] ON [dbo].[NBOMNT_UsercontrolProperties] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NBOMNT_UserControls] ON [dbo].[NBOMNT_UserControls] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ImageID] ON [dbo].[News_Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_News_Image] ON [dbo].[News_Images] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_News_ImageM] ON [dbo].[News_ImagesM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_News_Videos] ON [dbo].[News_Videos] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_News_ZipCodes] ON [dbo].[News_ZipCodes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_News_Zipcodes_ArticleDate] ON [dbo].[News_ZipCodes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_News_ZipCodes_ZipCodesID] ON [dbo].[News_ZipCodes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_News_ZipNisCodes] ON [dbo].[News_ZipCodes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsAlerMailtList] ON [dbo].[NewsAlertMailList] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ArticleId] ON [dbo].[NewsBySections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Primary] ON [dbo].[NewsBySections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_SectionID] ON [dbo].[NewsBySections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [idx_article_id] ON [dbo].[NewsbySubsections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [idx_subsectionid] ON [dbo].[NewsbySubsections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsBySubsections_ArticleID_SubsectionID_OrderNumber] ON [dbo].[NewsbySubsections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsBySubsections_SubsectionID_ArticleID_OrderNumber] ON [dbo].[NewsbySubsections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsbySubsections] ON [dbo].[NewsbySubsections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsbySubsectionsM] ON [dbo].[NewsbySubsectionsM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IxArticleId] ON [dbo].[NewsDebate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IxDebateId] ON [dbo].[NewsDebate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsDebate] ON [dbo].[NewsDebate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__NewsInternalInfo__286F8692] ON [dbo].[NewsInternalInfoFlags] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newsletter] ON [dbo].[Newsletter] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newsletter_Config] ON [dbo].[Newsletter_Config] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newsletter_Mailing] ON [dbo].[Newsletter_Mailing] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newsletter_Mailing_Article] ON [dbo].[Newsletter_Mailing_Article] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newsletter_Mailing_Status] ON [dbo].[Newsletter_Mailing_Status] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newsletter_Status] ON [dbo].[Newsletter_Status] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsSearchToday] ON [dbo].[NewsSearchDSO] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [DateIndex] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Indx_ArticleType] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Indx_atricleDate] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Indx_InputType] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_1] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_2] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_3] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_ArticleContentType] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_ExternalId] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_For_SearchCopy] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_PdfPageID] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_ShowOnline_Preview] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_ShowOnline_Secure_Preview_PaperCode] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_TimeStamp] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_Title] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Secure] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_snelnieuws] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ZipCodeNews] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [NewsTableMain42] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [NewsTableMain43] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsTableMain] ON [dbo].[NewsTableMain] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsTableMain_MetaData] ON [dbo].[NewsTableMain_MetaData] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsTableMain_MetaDataM] ON [dbo].[NewsTableMain_MetaDataM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ArticleId] ON [dbo].[NewsTableMain_Paper_MetaData] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_Paper_MetaData_StickyExpiration_PaperCode] ON [dbo].[NewsTableMain_Paper_MetaData] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PaperCode] ON [dbo].[NewsTableMain_Paper_MetaData] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ArticleId_PaperCode] ON [dbo].[NewsTableMain_Paper_MetaData] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ArticleId] ON [dbo].[NewsTableMain_PdfPage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PdfPageId] ON [dbo].[NewsTableMain_PdfPage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsTableMain_Profiles] ON [dbo].[NewsTableMain_Profiles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Ix_ArticleId] ON [dbo].[NewsTableMain_Quote] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_QuoteId] ON [dbo].[NewsTableMain_Quote] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ArticleID] ON [dbo].[NewsTableMain_Section] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Section] ON [dbo].[NewsTableMain_Section] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsTableMain_Section] ON [dbo].[NewsTableMain_Section] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Newstablemain_Secure_Temp] ON [dbo].[Newstablemain_Secure_Temp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NewsTableMain_ZipCodes_Master] ON [dbo].[NewsTableMain_ZipCodes_Master] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_NewsTableMain_ZipCodes_Master] ON [dbo].[NewsTableMain_ZipCodes_Master] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Papers] ON [dbo].[Papers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PartnerReferrer] ON [dbo].[PartnerReferrer] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PdfLeftNav] ON [dbo].[PdfLeftNav] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PdfPage_SubSection_Date] ON [dbo].[PdfPage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PdfPage--PRED--PageDate-MainSectionCode] ON [dbo].[PdfPage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PdfPage] ON [dbo].[PdfPage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PdfPageTmp_[ArticleID]]] ON [dbo].[PdfPageTmp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PdfPageTmp] ON [dbo].[PdfPageTmp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PdfSection] ON [dbo].[PdfSection] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PDFMapping_ABREV_Section] ON [dbo].[PdfSectionMapping] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PdfPageSection] ON [dbo].[PdfSectionMapping] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Permissions] ON [dbo].[Permissions] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PermissionTypes] ON [dbo].[PermissionTypes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Photos] ON [dbo].[Photos] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Profession] ON [dbo].[Profession] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ProfileGroups] ON [dbo].[ProfileGroups] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ProfileKeywords] ON [dbo].[ProfileKeywords] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Profiles] ON [dbo].[Profiles] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Promobox] ON [dbo].[Promobox] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__PromoBoxSections__3EFC4F81] ON [dbo].[PromoBoxSections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Promopipe] ON [dbo].[Promopipe] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_PromoPipebox_All] ON [dbo].[PromoPipeBox] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PromoPipeBox] ON [dbo].[PromoPipeBox] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_PromoPipeMapping] ON [dbo].[PromoPipeMapping] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Provinces] ON [dbo].[Provinces] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__PublishStatus__4BEDCCF9] ON [dbo].[PublishStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RecentNews_ArticleContentType] ON [dbo].[RecentNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Ix_Recentnews_ArticleID] ON [dbo].[RecentNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RecentNews_BYZipCode] ON [dbo].[RecentNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Ix_Recentnews_main] ON [dbo].[RecentNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_RecentNews_Section_Id] ON [dbo].[RecentNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_RecentNews_1] ON [dbo].[RecentNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_RecentNews_BackLog] ON [dbo].[RecentNews_BackLog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Redirects] ON [dbo].[Redirects] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Schoolverslagen_Postcode] ON [dbo].[Schoolverslagen] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Id] ON [dbo].[Section] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Section_Sid] ON [dbo].[Section] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__Section__4FBE5DDD] ON [dbo].[Section] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Sections] ON [dbo].[Sections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Sections] ON [dbo].[Sections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SectionsByUser] ON [dbo].[SectionsByUser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Sectors] ON [dbo].[Sectors] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SourceOfOrigin] ON [dbo].[SourceOfOrigin] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_spaarBon] ON [dbo].[spaarBon] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SpaarBonUser] ON [dbo].[SpaarBonUser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_StartPages] ON [dbo].[StartPages] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Exchanges] ON [dbo].[StockExchanges] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [UK_StockExchanges_Code] ON [dbo].[StockExchanges] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Stocks] ON [dbo].[Stocks] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [UK_Stocks_ChiXStockId] ON [dbo].[Stocks] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Street] ON [dbo].[Street] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SubscriptionTopics] ON [dbo].[SubscriptionTopics] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Indx_SectionID] ON [dbo].[SubSections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SubSections] ON [dbo].[SubSections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [SubSections23] ON [dbo].[SubSections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [subsections25] ON [dbo].[SubSections] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Survey_ExternalId] ON [dbo].[Survey] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_SurveyType] ON [dbo].[Survey] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Survey] ON [dbo].[Survey] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_SurveyQuestion_ExternalId] ON [dbo].[SurveyQuestion] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyQuestion] ON [dbo].[SurveyQuestion] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [SurveyId] ON [dbo].[SurveyQuestion] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Choice] ON [dbo].[SurveyQuestionChoice] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_SurveyQuestionChoice_ExternalId] ON [dbo].[SurveyQuestionChoice] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [order] ON [dbo].[SurveyQuestionChoice] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyQuestionChoice] ON [dbo].[SurveyQuestionChoice] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [SurveyQuestionId] ON [dbo].[SurveyQuestionChoice] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyQuestionType] ON [dbo].[SurveyQuestionType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyResponse] ON [dbo].[SurveyResponse] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyResponseEnquete] ON [dbo].[SurveyResponseEnquete] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_SurveyResponseUser] ON [dbo].[SurveyResponseUser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyResponseUser] ON [dbo].[SurveyResponseUser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [SurveyQuestionId] ON [dbo].[SurveyResponseUser] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyStatus] ON [dbo].[SurveyStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_SurveyType] ON [dbo].[SurveyType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_temp_clean] ON [dbo].[temp_clean] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_temp_optizen] ON [dbo].[temp_optizen] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__temp_profiler__12E98E70] ON [dbo].[temp_profiler] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_temp_schorsing] ON [dbo].[temp_schorsing] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_TempExportPollUsers] ON [dbo].[TempExportPollUsers] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ThemaFicheNews] ON [dbo].[ThemaFicheNews] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__trace__7BA701BC] ON [dbo].[trace] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__TRACE_TABLE_NAME__69927322] ON [dbo].[TRACE_TABLE_NAME] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__trace2__7E0E6D1B] ON [dbo].[trace2] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__Untitled - 1__6B7ABB94] ON [dbo].[TraceIV] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_tshirtgentenaar] ON [dbo].[tshirtgentenaar] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__UGCPhoto__47932C30] ON [dbo].[UGCPhoto] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__UGCPhoto_Counter__049C3A70] ON [dbo].[UGCPhoto_Counter_Tmp] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UGCPhoto_Debate] ON [dbo].[UGCPhoto_Debate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UGCPhotoCategory] ON [dbo].[UGCPhotoCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__UGCPhotoSpecial__42CE7713] ON [dbo].[UGCPhotoSpecial] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UGCPhotoSpecial_Category] ON [dbo].[UGCPhotoSpecial_Category] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UrlRewriteActions] ON [dbo].[UrlRewriteActions] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UrlRewriteRules_PaperCode] ON [dbo].[UrlRewriteRules] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UrlRewriteRules] ON [dbo].[UrlRewriteRules] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_User_Archive] ON [dbo].[User_Archive] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_User_Keyword] ON [dbo].[User_Keyword] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_User_Keyword_Found] ON [dbo].[User_Keyword_Found] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UserEzine] ON [dbo].[UserEzine_old] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__UserMnt__2CAA2BCA] ON [dbo].[UserMnt] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__UserMnt_Blog__391002AF] ON [dbo].[UserMnt_Blog] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserMnt_Blog_News_Article] ON [dbo].[UserMnt_Blog_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserMnt_Blog_News_Blog] ON [dbo].[UserMnt_Blog_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserMnt_Blog_News_User] ON [dbo].[UserMnt_Blog_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__UserMnt_Blog_New__4669FDCD] ON [dbo].[UserMnt_Blog_News] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UserProfile] ON [dbo].[UserProfile] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_AccountGuid] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_AccountId] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_Active] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_Country] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_Email] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_groupid] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_NewsAlerts] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NickName] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_SopresKey] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Users] ON [dbo].[Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserId] ON [dbo].[UsersAccess] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UsersAccess] ON [dbo].[UsersAccess] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserId] ON [dbo].[UsersAccess_old] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UsersAccess_old] ON [dbo].[UsersAccess_old] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_accountGUID] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_accountId] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_active] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_lastname] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [index_zipcode] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ix_email] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_NickName] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_UserVum] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UserVum] ON [dbo].[UserVum] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_UserVumEzine] ON [dbo].[UserVumEzine_old] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Verkiezingen_Lijst_Partij] ON [dbo].[Verkiezingen_Lijst_Partij] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Verkiezingen_Lijsten] ON [dbo].[Verkiezingen_Lijsten] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Verkiezingen_Partijen] ON [dbo].[Verkiezingen_Partijen] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Verkiezingen_Politici] ON [dbo].[Verkiezingen_Politici] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Verkiezingen_Users] ON [dbo].[Verkiezingen_Users] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Verkiezingen_Votelist] ON [dbo].[Verkiezingen_Votelist] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_Video_ExternalId] ON [dbo].[Video] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Video] ON [dbo].[Video] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Video_Category] ON [dbo].[Video] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Video_Titel] ON [dbo].[Video] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Video_Category] ON [dbo].[Video_Category] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [CategoryId] ON [dbo].[Video_SubCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Video_SubCategory] ON [dbo].[Video_SubCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VideoTransferInfo] ON [dbo].[VideoTransferInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VideoZipcode] ON [dbo].[VideoZipcode] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK__Visibility__4DD6156B] ON [dbo].[Visibility] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_AccessCode] ON [dbo].[VUM_AccessCode] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_vum_article_survey] ON [dbo].[vum_article_survey] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_HtmlTemplate] ON [dbo].[VUM_EmailTemplate] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_ftv_ArticleItem] ON [dbo].[VUM_Ftv_ArticleItem] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_Ftv_Category] ON [dbo].[VUM_Ftv_Category] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_Ftv_CategoryItem] ON [dbo].[VUM_Ftv_CategoryItem] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_VUM_Ftv_PaperCode] ON [dbo].[VUM_Ftv_Item] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_Ftv_Item] ON [dbo].[VUM_Ftv_Item] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [AccessCode] ON [dbo].[VUM_SessionInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [AccessType] ON [dbo].[VUM_SessionInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Active] ON [dbo].[VUM_SessionInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [ExpiredDate] ON [dbo].[VUM_SessionInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_VUM_SessionInfo] ON [dbo].[VUM_SessionInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [Userid] ON [dbo].[VUM_SessionInfo] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_WT_Export_Inc] ON [dbo].[WT_Export_Inc] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, IGNORE_DUP_KEY = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ZipCode] ON [dbo].[ZipCode] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [IX_ZipCodes_ZipCodeMaster] ON [dbo].[ZipCodes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ZipCode2] ON [dbo].[ZipCodes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_ZipCodes_NeighborCities_1] ON [dbo].[ZipCodes_NeighborCities] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
ALTER INDEX [PK_Zones] ON [dbo].[Zones] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105_P]
GO
SET ARITHABORT ON
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET ARITHABORT ON
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
DBCC DBREINDEX(N'[dbo].[UVW_CORELIO_ArticleReactionCount]', N'IX_DEBATEREACTIONS_BY_ARTICLE_UNIQUE', 0)
GO
USE [A105_P]
GO
SET ARITHABORT ON
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET ARITHABORT ON
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
DBCC DBREINDEX(N'[dbo].[UVW_ExtraArticles_New]', N'PK_UVW_ExtraArticles_New', 0)
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE] ON [dbo].[COMPETITIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_CATEGORIE] ON [dbo].[COMPETITIE_CATEGORIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_KLASSE] ON [dbo].[COMPETITIE_KLASSE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_OFFICIAL] ON [dbo].[COMPETITIE_OFFICIAL] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_PERIODE_RANGSCHIKKING] ON [dbo].[COMPETITIE_PERIODE_RANGSCHIKKING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [competitie_code] ON [dbo].[COMPETITIE_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_PLOEG] ON [dbo].[COMPETITIE_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_RANGSCHIKKING] ON [dbo].[COMPETITIE_RANGSCHIKKING] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_SEIZOEN] ON [dbo].[COMPETITIE_SEIZOEN] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_COMPETITIE_Code] ON [dbo].[COMPETITIE_SPEELDAG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_SPEELDAG] ON [dbo].[COMPETITIE_SPEELDAG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_SPEELDAG_DATUM] ON [dbo].[COMPETITIE_SPEELDAG_DATUM] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_SPORTER] ON [dbo].[COMPETITIE_SPORTER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_COMPETITIE_TOP_SCORE] ON [dbo].[COMPETITIE_TOP] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_OFFICIAL] ON [dbo].[OFFICIAL] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_OFFICIAL_TYPE] ON [dbo].[OFFICIAL_TYPE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_OPSTELLING_TYPE] ON [dbo].[OPSTELLING_TYPE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_Ploeg_DossierId] ON [dbo].[PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_PLOEG] ON [dbo].[PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_POPUP_KLANT] ON [dbo].[POPUP_KLANT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_POPUP_KLASSE] ON [dbo].[POPUP_KLASSE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_PROVINCIE] ON [dbo].[PROVINCIE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_SPORT] ON [dbo].[SPORT] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_Sport_be_Competition] ON [dbo].[Sport_be_Competition] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_Sport_be_Result] ON [dbo].[Sport_be_Game] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_Sport_be_Period] ON [dbo].[Sport_be_Period] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_Player] ON [dbo].[Sport_be_Player] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_Team] ON [dbo].[Sport_be_Team] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_SPORTER] ON [dbo].[SPORTER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_TOP_TYPE] ON [dbo].[TOP_TYPE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_UITSLAGEN_LOG] ON [dbo].[UITSLAGEN_LOG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [competitie_ploeg_thuis_code] ON [dbo].[WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [competitie_ploeg_uit_code] ON [dbo].[WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_WEDSTRIJD_ARTICLEID] ON [dbo].[WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_WEDSTRIJD_SPEELDAG_CODE] ON [dbo].[WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD] ON [dbo].[WEDSTRIJD] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_OFFICIAL] ON [dbo].[WEDSTRIJD_OFFICIAL] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_PERIODE] ON [dbo].[WEDSTRIJD_PERIODE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_PERIODE_TYPE] ON [dbo].[WEDSTRIJD_PERIODE_TYPE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_Wedstrijd_Ploeg_Wedstrijd_Code] ON [dbo].[WEDSTRIJD_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_PLOEG] ON [dbo].[WEDSTRIJD_PLOEG] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_Wedstrijd_Ploeg_Sporter_Competetie_Sporter_Code] ON [dbo].[WEDSTRIJD_PLOEG_SPORTER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_Wedstrijd_Ploeg_Sporter_Opstelling_Type_Code] ON [dbo].[WEDSTRIJD_PLOEG_SPORTER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_Wedstrijd_Ploeg_Sporter_Wedstrijd_Ploeg_Code] ON [dbo].[WEDSTRIJD_PLOEG_SPORTER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_PLOEG_SPORTER] ON [dbo].[WEDSTRIJD_PLOEG_SPORTER] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_STATUS] ON [dbo].[WEDSTRIJD_STATUS] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_TYPE] ON [dbo].[WEDSTRIJD_TYPE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WEDSTRIJD_VERLOOP_TYPE_CODE] ON [dbo].[WEDSTRIJD_VERLOOP_TYPE_CODE] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesAvgUnits] ON [dbo].[WRCodesAvgUnits] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesClassification] ON [dbo].[WRCodesClassification] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesDistance] ON [dbo].[WRCodesDistance] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [IX_WRCodesLand] ON [dbo].[WRCodesLand] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesLand] ON [dbo].[WRCodesLand] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesPloegTypes] ON [dbo].[WRCodesPloegTypes] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesRaceCategory] ON [dbo].[WRCodesRaceCategory] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesRaceType] ON [dbo].[WRCodesRaceType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesResultStatus] ON [dbo].[WRCodesResultStatus] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesStageType] ON [dbo].[WRCodesStageType] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRCodesStageType2] ON [dbo].[WRCodesStageType2] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRRace] ON [dbo].[WRRace] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRResult] ON [dbo].[WRResult] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRResultRider] ON [dbo].[WRResultRider] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRRider] ON [dbo].[WRRider] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRRiderTeam] ON [dbo].[WRRiderTeam] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRSeason] ON [dbo].[WRSeason] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRStage] ON [dbo].[WRStage] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )
GO
USE [A105.SPO_P]
GO
ALTER INDEX [PK_WRTeam] ON [dbo].[WRTeam] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )


Error:
Message
Executed as user: CORP\sql2k5service. ...10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 Progress: 2011-07-02 02:00:01.05 Source: {04E24E2D-69DB-4AB6-AF3A-9F790B94B799} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2011-07-02 02:00:16.23 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 0% complete End Progress Progress: 2011-07-02 02:00:17.01 Source: Rebuild Index Task Executing query "ALTER INDEX [PK__NewBoSecurityCheck] ON [dbo].[_Ne...".: 0% complete End Progress Progress: 2011-07-02 02:00:17.01 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 0% complete End Progress Progress: 2011-07-02 02:00:17.10 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboActivationCode] ON [dbo].[AboAc...".: 0% complete End Progress Progress: 2011-07-02 02:00:17.10 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 0% complete End Progress Progress: 2011-07-02 02:00:17.25 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboActive] ON [dbo].[AboActive] RE...".: 0% complete End Progress Progress: 2011-07-02 02:00:17.25 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 0% complete End Progress Progress: 2011-07-02 02:00:17.29 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_DSO_AboCondition] ON [dbo].[AboCon...".: 0% complete End Progress Progress: 2011-07-02 02:00:17.29 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 0% complete End Progress Progress: 2011-07-02 02:00:17.32 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboEmailReminder] ON [dbo].[AboEma...".: 0% complete End Progress Progress: 2011-07-02 02:00:17.32 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 0% complete End Progress Progress: 2011-07-02 02:00:17.70 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboEmailReminderSent] ON [dbo].[Ab...".: 1% complete End Progress Progress: 2011-07-02 02:00:17.70 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 1% complete End Progress Progress: 2011-07-02 02:00:18.12 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboOrder] ON [dbo].[AboOrder] REBU...".: 1% complete End Progress Progress: 2011-07-02 02:00:18.12 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 1% complete End Progress Progress: 2011-07-02 02:00:18.24 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboOrderSAP] ON [dbo].[AboOrderSAP...".: 1% complete End Progress Progress: 2011-07-02 02:00:18.24 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 1% complete End Progress Progress: 2011-07-02 02:00:18.26 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_Abo] ON [dbo].[AboProduct] REBUILD...".: 1% complete End Progress Progress: 2011-07-02 02:00:18.26 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 1% complete End Progress Progress: 2011-07-02 02:00:18.27 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboProductCollection] ON [dbo].[Ab...".: 1% complete End Progress Progress: 2011-07-02 02:00:18.27 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 1% complete End Progress Progress: 2011-07-02 02:00:18.48 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboProductEmail] ON [dbo].[AboProd...".: 1% complete End Progress Progress: 2011-07-02 02:00:18.48 Source: Rebuild Index Task Executing query "USE [A105_P] ".: 1% complete End Progress Progress: 2011-07-02 02:00:18.48 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_AboProductType] ON [dbo].[AboProdu...".: 2% complete End Prog... The package execution fa... The step failed.
Post #1135776
Posted Monday, July 04, 2011 2:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:25 PM
Points: 1,153, Visits: 4,603
maintenance plan error pls

Just expand the MP and right click the job view the error and paste it.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1135779
Posted Monday, July 04, 2011 3:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 10:43 AM
Points: 389, Visits: 305
This is the generated output:
http://users.telenet.be/rhox/DBA/RebuildIndexError.txt
Post #1135788
Posted Monday, July 04, 2011 3:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:25 PM
Points: 1,153, Visits: 4,603
Rhox (7/4/2011)
This is the generated output:
http://users.telenet.be/rhox/DBA/RebuildIndexError.txt


Failed-1073548784) Executing the query "ALTER INDEX [IX_RootID_Approved_rLevel_CreatedOn_P..." failed with the following error: "Transaction (Process ID 85) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

The error clearly says you got deadlock while running this.

Check the job time and find if is there any other jobs or anything running on the same time. Keep monitor it. If you want take the deadlock graph and analyze it


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1135791
Posted Monday, July 04, 2011 3:24 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 10:43 AM
Points: 389, Visits: 305
At the same time, there's a:
- Backup transaction log
- Job History (syspolicy_purge_history)

That's all, if I'm not mistaken, this will not interupt the index rebuild?
Post #1135799
Posted Monday, July 04, 2011 3:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:25 PM
Points: 1,153, Visits: 4,603
Rhox (7/4/2011)
At the same time, there's a:
- Backup transaction log
- Job History (syspolicy_purge_history)

That's all, if I'm not mistaken, this will not interupt the index rebuild?


Yes this will not do anything. Is there any user activity on that rebuild time.

I suggest to change the rebulid time (e.x 1am to 2am) and check it out tonight.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1135802
Posted Monday, July 04, 2011 3:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 10:43 AM
Points: 389, Visits: 305
Ok, I will try that and reply here tomorrow.
Thanks for your help already!
Post #1135805
Posted Monday, July 04, 2011 4:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 5,970, Visits: 12,869
you might also want to configure a mail profile for database mail so that the stored procedure SP_NOTIFY_OPERATOR doesn't fail too!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1135821
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse