July 4, 2011 at 2:18 am
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 🙁
July 4, 2011 at 2:27 am
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
https://www.sqlserverblogforum.com/
July 4, 2011 at 2:44 am
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.
July 4, 2011 at 2:48 am
maintenance plan error pls
Just expand the MP and right click the job view the error and paste it.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 4, 2011 at 3:03 am
This is the generated output:
July 4, 2011 at 3:09 am
Rhox (7/4/2011)
This is the generated output:
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
https://www.sqlserverblogforum.com/
July 4, 2011 at 3:24 am
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?
July 4, 2011 at 3:27 am
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
https://www.sqlserverblogforum.com/
July 4, 2011 at 3:32 am
Ok, I will try that and reply here tomorrow.
Thanks for your help already!
July 4, 2011 at 4:14 am
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" 😉
July 4, 2011 at 4:53 am
Perry Whittle (7/4/2011)
you might also want to configure a mail profile for database mail so that the stored procedure SP_NOTIFY_OPERATOR doesn't fail too! 😉
That's solved already, it missed the default profile 🙂
July 4, 2011 at 5:02 am
I was searching for a good index optimalisation script.
That reorganised or rebuild the indexes (online) for the database.
I'm trying following script: Example Script to Rebuild / Reorganize Fragmented Indexes
I've modified only the rebuild command line with the extra option 'ONLINE = ON'.
But I'm always getting an error: Incorrect syntax near '('. on Line 38
LINE38 > FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL , NULL) IPS
I noticed the compatibility mode of our db = 80 (SQL 2000)
Already changed DB_ID() into 'A105_P' (the db name) but then I get this output (scripted error):
DATE : Jul 4 2011 1:01PM - Retrieving indexes with high fragmentation from A105_P database.
DATE : Jul 4 2011 1:01PM - There is some run time exception.
ERROR CODE : 245
ERROR MESSAGE : Conversion failed when converting the varchar value 'A105_P' to data type smallint.
July 4, 2011 at 5:17 am
#1 This script is more complete and customizable
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
#2 You can run the query without any modification. You just have to run it from master (or any other db that is in compat mode 90+)... but for the 80s dbs.
The other workaround is to use the dbid. I think your problem is that you are using the db name instead of the id().
July 4, 2011 at 5:18 am
I concur, Michelle's script is awesome.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:29 am
Incorrect syntax near '('. on Line 38
LINE38 > FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL , NULL) IPS
I noticed the compatibility mode of our db = 80 (SQL 2000)
Already changed DB_ID() into 'A105_P' (the db name) but then I get this output (scripted error):
DATE : Jul 4 2011 1:01PM - Retrieving indexes with high fragmentation from A105_P database.
DATE : Jul 4 2011 1:01PM - There is some run time exception.
ERROR CODE : 245
ERROR MESSAGE : Conversion failed when converting the varchar value 'A105_P' to data type smallint.
You can't pass the db name directly 'A105_P' to the db_id . use like db_id('A105_P')
DMV will not work against the compatibility 80.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply