Update table stats

updatestats.sql

--select '
--PRINT ''Updating ' + [name] + '''
--UPDATE STATISTICS [dbo].[' + [name] + ']
--'
--from sysobjects where type = 'U'
--and name <> '__MigrationHistory'
--order by [name]

PRINT 'Updating _org_sparkdevnetwork_Documentation_Book'
UPDATE STATISTICS [dbo].[_org_sparkdevnetwork_Documentation_Book]

PRINT 'Updating _org_sparkdevnetwork_Documentation_BookVersion'
UPDATE STATISTICS [dbo].[_org_sparkdevnetwork_Documentation_BookVersion]

PRINT 'Updating _org_sparkdevnetwork_Documentation_Chapter'
UPDATE STATISTICS [dbo].[_org_sparkdevnetwork_Documentation_Chapter]

PRINT 'Updating Attendance'
UPDATE STATISTICS [dbo].[Attendance]

PRINT 'Updating AttendanceCode'
UPDATE STATISTICS [dbo].[AttendanceCode]

PRINT 'Updating Attribute'
UPDATE STATISTICS [dbo].[Attribute]

PRINT 'Updating AttributeCategory'
UPDATE STATISTICS [dbo].[AttributeCategory]

PRINT 'Updating AttributeQualifier'
UPDATE STATISTICS [dbo].[AttributeQualifier]

PRINT 'Updating AttributeValue'
UPDATE STATISTICS [dbo].[AttributeValue]

PRINT 'Updating Audit'
UPDATE STATISTICS [dbo].[Audit]

PRINT 'Updating AuditDetail'
UPDATE STATISTICS [dbo].[AuditDetail]

PRINT 'Updating Auth'
UPDATE STATISTICS [dbo].[Auth]

PRINT 'Updating BackgroundCheck'
UPDATE STATISTICS [dbo].[BackgroundCheck]

PRINT 'Updating BenevolenceRequest'
UPDATE STATISTICS [dbo].[BenevolenceRequest]

PRINT 'Updating BenevolenceResult'
UPDATE STATISTICS [dbo].[BenevolenceResult]

PRINT 'Updating BinaryFile'
UPDATE STATISTICS [dbo].[BinaryFile]

PRINT 'Updating BinaryFileData'
UPDATE STATISTICS [dbo].[BinaryFileData]

PRINT 'Updating BinaryFileType'
UPDATE STATISTICS [dbo].[BinaryFileType]

PRINT 'Updating Block'
UPDATE STATISTICS [dbo].[Block]

PRINT 'Updating BlockType'
UPDATE STATISTICS [dbo].[BlockType]

PRINT 'Updating Campus'
UPDATE STATISTICS [dbo].[Campus]

PRINT 'Updating Category'
UPDATE STATISTICS [dbo].[Category]

PRINT 'Updating Communication'
UPDATE STATISTICS [dbo].[Communication]

PRINT 'Updating CommunicationRecipient'
UPDATE STATISTICS [dbo].[CommunicationRecipient]

PRINT 'Updating CommunicationRecipientActivity'
UPDATE STATISTICS [dbo].[CommunicationRecipientActivity]

PRINT 'Updating CommunicationTemplate'
UPDATE STATISTICS [dbo].[CommunicationTemplate]

PRINT 'Updating ConnectionActivityType'
UPDATE STATISTICS [dbo].[ConnectionActivityType]

PRINT 'Updating ConnectionOpportunity'
UPDATE STATISTICS [dbo].[ConnectionOpportunity]

PRINT 'Updating ConnectionOpportunityCampus'
UPDATE STATISTICS [dbo].[ConnectionOpportunityCampus]

PRINT 'Updating ConnectionOpportunityConnectorGroup'
UPDATE STATISTICS [dbo].[ConnectionOpportunityConnectorGroup]

PRINT 'Updating ConnectionOpportunityGroup'
UPDATE STATISTICS [dbo].[ConnectionOpportunityGroup]

PRINT 'Updating ConnectionRequest'
UPDATE STATISTICS [dbo].[ConnectionRequest]

PRINT 'Updating ConnectionRequestActivity'
UPDATE STATISTICS [dbo].[ConnectionRequestActivity]

PRINT 'Updating ConnectionRequestWorkflow'
UPDATE STATISTICS [dbo].[ConnectionRequestWorkflow]

PRINT 'Updating ConnectionStatus'
UPDATE STATISTICS [dbo].[ConnectionStatus]

PRINT 'Updating ConnectionType'
UPDATE STATISTICS [dbo].[ConnectionType]

PRINT 'Updating ConnectionWorkflow'
UPDATE STATISTICS [dbo].[ConnectionWorkflow]

PRINT 'Updating ContentChannel'
UPDATE STATISTICS [dbo].[ContentChannel]

PRINT 'Updating ContentChannelItem'
UPDATE STATISTICS [dbo].[ContentChannelItem]

PRINT 'Updating ContentChannelType'
UPDATE STATISTICS [dbo].[ContentChannelType]

PRINT 'Updating DataView'
UPDATE STATISTICS [dbo].[DataView]

PRINT 'Updating DataViewFilter'
UPDATE STATISTICS [dbo].[DataViewFilter]

PRINT 'Updating DefinedType'
UPDATE STATISTICS [dbo].[DefinedType]

PRINT 'Updating DefinedValue'
UPDATE STATISTICS [dbo].[DefinedValue]

PRINT 'Updating Device'
UPDATE STATISTICS [dbo].[Device]

PRINT 'Updating DeviceLocation'
UPDATE STATISTICS [dbo].[DeviceLocation]

PRINT 'Updating EntitySet'
UPDATE STATISTICS [dbo].[EntitySet]

PRINT 'Updating EntitySetItem'
UPDATE STATISTICS [dbo].[EntitySetItem]

PRINT 'Updating EntityType'
UPDATE STATISTICS [dbo].[EntityType]

PRINT 'Updating EventCalendar'
UPDATE STATISTICS [dbo].[EventCalendar]

PRINT 'Updating EventCalendarContentChannel'
UPDATE STATISTICS [dbo].[EventCalendarContentChannel]

PRINT 'Updating EventCalendarItem'
UPDATE STATISTICS [dbo].[EventCalendarItem]

PRINT 'Updating EventItem'
UPDATE STATISTICS [dbo].[EventItem]

PRINT 'Updating EventItemAudience'
UPDATE STATISTICS [dbo].[EventItemAudience]

PRINT 'Updating EventItemOccurrence'
UPDATE STATISTICS [dbo].[EventItemOccurrence]

PRINT 'Updating EventItemOccurrenceChannelItem'
UPDATE STATISTICS [dbo].[EventItemOccurrenceChannelItem]

PRINT 'Updating EventItemOccurrenceGroupMap'
UPDATE STATISTICS [dbo].[EventItemOccurrenceGroupMap]

PRINT 'Updating ExceptionLog'
UPDATE STATISTICS [dbo].[ExceptionLog]

PRINT 'Updating FieldType'
UPDATE STATISTICS [dbo].[FieldType]

PRINT 'Updating FinancialAccount'
UPDATE STATISTICS [dbo].[FinancialAccount]

PRINT 'Updating FinancialBatch'
UPDATE STATISTICS [dbo].[FinancialBatch]

PRINT 'Updating FinancialGateway'
UPDATE STATISTICS [dbo].[FinancialGateway]

PRINT 'Updating FinancialPaymentDetail'
UPDATE STATISTICS [dbo].[FinancialPaymentDetail]

PRINT 'Updating FinancialPersonBankAccount'
UPDATE STATISTICS [dbo].[FinancialPersonBankAccount]

PRINT 'Updating FinancialPersonSavedAccount'
UPDATE STATISTICS [dbo].[FinancialPersonSavedAccount]

PRINT 'Updating FinancialPledge'
UPDATE STATISTICS [dbo].[FinancialPledge]

PRINT 'Updating FinancialScheduledTransaction'
UPDATE STATISTICS [dbo].[FinancialScheduledTransaction]

PRINT 'Updating FinancialScheduledTransactionDetail'
UPDATE STATISTICS [dbo].[FinancialScheduledTransactionDetail]

PRINT 'Updating FinancialTransaction'
UPDATE STATISTICS [dbo].[FinancialTransaction]

PRINT 'Updating FinancialTransactionDetail'
UPDATE STATISTICS [dbo].[FinancialTransactionDetail]

PRINT 'Updating FinancialTransactionImage'
UPDATE STATISTICS [dbo].[FinancialTransactionImage]

PRINT 'Updating FinancialTransactionRefund'
UPDATE STATISTICS [dbo].[FinancialTransactionRefund]

PRINT 'Updating Following'
UPDATE STATISTICS [dbo].[Following]

PRINT 'Updating FollowingEventNotification'
UPDATE STATISTICS [dbo].[FollowingEventNotification]

PRINT 'Updating FollowingEventSubscription'
UPDATE STATISTICS [dbo].[FollowingEventSubscription]

PRINT 'Updating FollowingEventType'
UPDATE STATISTICS [dbo].[FollowingEventType]

PRINT 'Updating FollowingSuggested'
UPDATE STATISTICS [dbo].[FollowingSuggested]

PRINT 'Updating FollowingSuggestionType'
UPDATE STATISTICS [dbo].[FollowingSuggestionType]

PRINT 'Updating Group'
UPDATE STATISTICS [dbo].[Group]

PRINT 'Updating GroupLocation'
UPDATE STATISTICS [dbo].[GroupLocation]

PRINT 'Updating GroupLocationSchedule'
UPDATE STATISTICS [dbo].[GroupLocationSchedule]

PRINT 'Updating GroupMember'
UPDATE STATISTICS [dbo].[GroupMember]

PRINT 'Updating GroupMemberRequirement'
UPDATE STATISTICS [dbo].[GroupMemberRequirement]

PRINT 'Updating GroupMemberWorkflowTrigger'
UPDATE STATISTICS [dbo].[GroupMemberWorkflowTrigger]

PRINT 'Updating GroupRequirement'
UPDATE STATISTICS [dbo].[GroupRequirement]

PRINT 'Updating GroupRequirementType'
UPDATE STATISTICS [dbo].[GroupRequirementType]

PRINT 'Updating GroupScheduleExclusion'
UPDATE STATISTICS [dbo].[GroupScheduleExclusion]

PRINT 'Updating GroupType'
UPDATE STATISTICS [dbo].[GroupType]

PRINT 'Updating GroupTypeAssociation'
UPDATE STATISTICS [dbo].[GroupTypeAssociation]

PRINT 'Updating GroupTypeLocationType'
UPDATE STATISTICS [dbo].[GroupTypeLocationType]

PRINT 'Updating GroupTypeRole'
UPDATE STATISTICS [dbo].[GroupTypeRole]

PRINT 'Updating History'
UPDATE STATISTICS [dbo].[History]

PRINT 'Updating HtmlContent'
UPDATE STATISTICS [dbo].[HtmlContent]

PRINT 'Updating Layout'
UPDATE STATISTICS [dbo].[Layout]

PRINT 'Updating Location'
UPDATE STATISTICS [dbo].[Location]

PRINT 'Updating MergeTemplate'
UPDATE STATISTICS [dbo].[MergeTemplate]

PRINT 'Updating Metaphone'
UPDATE STATISTICS [dbo].[Metaphone]

PRINT 'Updating Metric'
UPDATE STATISTICS [dbo].[Metric]

PRINT 'Updating MetricCategory'
UPDATE STATISTICS [dbo].[MetricCategory]

PRINT 'Updating MetricValue'
UPDATE STATISTICS [dbo].[MetricValue]

PRINT 'Updating Note'
UPDATE STATISTICS [dbo].[Note]

PRINT 'Updating NoteType'
UPDATE STATISTICS [dbo].[NoteType]

PRINT 'Updating Page'
UPDATE STATISTICS [dbo].[Page]

PRINT 'Updating PageContext'
UPDATE STATISTICS [dbo].[PageContext]

PRINT 'Updating PageRoute'
UPDATE STATISTICS [dbo].[PageRoute]

PRINT 'Updating PageView'
UPDATE STATISTICS [dbo].[PageView]

PRINT 'Updating PageViewSession'
UPDATE STATISTICS [dbo].[PageViewSession]

PRINT 'Updating PageViewUserAgent'
UPDATE STATISTICS [dbo].[PageViewUserAgent]

PRINT 'Updating Person'
UPDATE STATISTICS [dbo].[Person]

PRINT 'Updating PersonAlias'
UPDATE STATISTICS [dbo].[PersonAlias]

PRINT 'Updating PersonBadge'
UPDATE STATISTICS [dbo].[PersonBadge]

PRINT 'Updating PersonDuplicate'
UPDATE STATISTICS [dbo].[PersonDuplicate]

PRINT 'Updating PersonPreviousName'
UPDATE STATISTICS [dbo].[PersonPreviousName]

PRINT 'Updating PersonViewed'
UPDATE STATISTICS [dbo].[PersonViewed]

PRINT 'Updating PhoneNumber'
UPDATE STATISTICS [dbo].[PhoneNumber]

PRINT 'Updating PluginMigration'
UPDATE STATISTICS [dbo].[PluginMigration]

PRINT 'Updating PrayerRequest'
UPDATE STATISTICS [dbo].[PrayerRequest]

PRINT 'Updating Registration'
UPDATE STATISTICS [dbo].[Registration]

PRINT 'Updating RegistrationInstance'
UPDATE STATISTICS [dbo].[RegistrationInstance]

PRINT 'Updating RegistrationRegistrant'
UPDATE STATISTICS [dbo].[RegistrationRegistrant]

PRINT 'Updating RegistrationRegistrantFee'
UPDATE STATISTICS [dbo].[RegistrationRegistrantFee]

PRINT 'Updating RegistrationTemplate'
UPDATE STATISTICS [dbo].[RegistrationTemplate]

PRINT 'Updating RegistrationTemplateDiscount'
UPDATE STATISTICS [dbo].[RegistrationTemplateDiscount]

PRINT 'Updating RegistrationTemplateFee'
UPDATE STATISTICS [dbo].[RegistrationTemplateFee]

PRINT 'Updating RegistrationTemplateForm'
UPDATE STATISTICS [dbo].[RegistrationTemplateForm]

PRINT 'Updating RegistrationTemplateFormField'
UPDATE STATISTICS [dbo].[RegistrationTemplateFormField]

PRINT 'Updating Report'
UPDATE STATISTICS [dbo].[Report]

PRINT 'Updating ReportField'
UPDATE STATISTICS [dbo].[ReportField]

PRINT 'Updating RestAction'
UPDATE STATISTICS [dbo].[RestAction]

PRINT 'Updating RestController'
UPDATE STATISTICS [dbo].[RestController]

PRINT 'Updating Schedule'
UPDATE STATISTICS [dbo].[Schedule]

PRINT 'Updating ServiceJob'
UPDATE STATISTICS [dbo].[ServiceJob]

PRINT 'Updating ServiceLog'
UPDATE STATISTICS [dbo].[ServiceLog]

PRINT 'Updating Site'
UPDATE STATISTICS [dbo].[Site]

PRINT 'Updating SiteDomain'
UPDATE STATISTICS [dbo].[SiteDomain]

PRINT 'Updating SystemEmail'
UPDATE STATISTICS [dbo].[SystemEmail]

PRINT 'Updating Tag'
UPDATE STATISTICS [dbo].[Tag]

PRINT 'Updating TaggedItem'
UPDATE STATISTICS [dbo].[TaggedItem]

PRINT 'Updating UserLogin'
UPDATE STATISTICS [dbo].[UserLogin]

PRINT 'Updating Workflow'
UPDATE STATISTICS [dbo].[Workflow]

PRINT 'Updating WorkflowAction'
UPDATE STATISTICS [dbo].[WorkflowAction]

PRINT 'Updating WorkflowActionForm'
UPDATE STATISTICS [dbo].[WorkflowActionForm]

PRINT 'Updating WorkflowActionFormAttribute'
UPDATE STATISTICS [dbo].[WorkflowActionFormAttribute]

PRINT 'Updating WorkflowActionType'
UPDATE STATISTICS [dbo].[WorkflowActionType]

PRINT 'Updating WorkflowActivity'
UPDATE STATISTICS [dbo].[WorkflowActivity]

PRINT 'Updating WorkflowActivityType'
UPDATE STATISTICS [dbo].[WorkflowActivityType]

PRINT 'Updating WorkflowLog'
UPDATE STATISTICS [dbo].[WorkflowLog]

PRINT 'Updating WorkflowTrigger'
UPDATE STATISTICS [dbo].[WorkflowTrigger]

PRINT 'Updating WorkflowType'
UPDATE STATISTICS [dbo].[WorkflowType]

DBCC FREEPROCCACHE