/****** Object: StoredProcedure [dbo].[proc_UpdateStatisticsNVP] Script Date: 08/12/2011 10:22:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[proc_UpdateStatisticsNVP] AS SET NOCOUNT ON DECLARE @command varchar(8000) IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Value' AND object_id = object_id(N'[dbo].[NameValuePair]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePair_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair] NameValuePair_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Albanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Albanian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAlbanian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Albanian_CI_AS] NameValuePair_Albanian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Arabic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Arabic_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairArabic_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Arabic_CI_AS] NameValuePair_Arabic_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_PRC_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_PRC_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_PRC_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_PRC_CI_AS] NameValuePair_Chinese_PRC_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_PRC_Stroke_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_PRC_Stroke_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS] NameValuePair_Chinese_PRC_Stroke_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Taiwan_Bopomofo_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS] NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Taiwan_Stroke_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Taiwan_Stroke_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS] NameValuePair_Chinese_Taiwan_Stroke_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Croatian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Croatian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCroatian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Croatian_CI_AS] NameValuePair_Croatian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Cyrillic_General_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Cyrillic_General_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCyrillic_General_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Cyrillic_General_CI_AS] NameValuePair_Cyrillic_General_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Czech_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Czech_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCzech_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Czech_CI_AS] NameValuePair_Czech_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Danish_Norwegian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Danish_Norwegian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairDanish_Norwegian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Danish_Norwegian_CI_AS] NameValuePair_Danish_Norwegian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Estonian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Estonian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairEstonian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Estonian_CI_AS] NameValuePair_Estonian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Finnish_Swedish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Finnish_Swedish_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairFinnish_Swedish_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Finnish_Swedish_CI_AS] NameValuePair_Finnish_Swedish_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_French_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_French_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairFrench_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_French_CI_AS] NameValuePair_French_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Georgian_Modern_Sort_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGeorgian_Modern_Sort_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS] NameValuePair_Georgian_Modern_Sort_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_German_PhoneBook_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_German_PhoneBook_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGerman_PhoneBook_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_German_PhoneBook_CI_AS] NameValuePair_German_PhoneBook_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Greek_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Greek_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGreek_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Greek_CI_AS] NameValuePair_Greek_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hebrew_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hebrew_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHebrew_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hebrew_CI_AS] NameValuePair_Hebrew_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hindi_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hindi_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHindi_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hindi_CI_AS] NameValuePair_Hindi_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hungarian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hungarian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHungarian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hungarian_CI_AS] NameValuePair_Hungarian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hungarian_Technical_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hungarian_Technical_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHungarian_Technical_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hungarian_Technical_CI_AS] NameValuePair_Hungarian_Technical_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Icelandic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Icelandic_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairIcelandic_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Icelandic_CI_AS] NameValuePair_Icelandic_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Japanese_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Japanese_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairJapanese_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Japanese_CI_AS] NameValuePair_Japanese_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Japanese_Unicode_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Japanese_Unicode_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairJapanese_Unicode_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Japanese_Unicode_CI_AS] NameValuePair_Japanese_Unicode_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Korean_Wansung_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Korean_Wansung_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKorean_Wansung_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Korean_Wansung_CI_AS] NameValuePair_Korean_Wansung_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Korean_Wansung_Unicode_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKorean_Wansung_Unicode_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS] NameValuePair_Korean_Wansung_Unicode_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Latin1_General_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Latin1_General_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLatin1_General_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Latin1_General_CI_AS] NameValuePair_Latin1_General_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Latvian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Latvian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLatvian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Latvian_CI_AS] NameValuePair_Latvian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Lithuanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Lithuanian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLithuanian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Lithuanian_CI_AS] NameValuePair_Lithuanian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Lithuanian_Classic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Lithuanian_Classic_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLithuanian_Classic_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Lithuanian_Classic_CI_AS] NameValuePair_Lithuanian_Classic_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Traditional_Spanish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Traditional_Spanish_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTraditional_Spanish_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Traditional_Spanish_CI_AS] NameValuePair_Traditional_Spanish_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Modern_Spanish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Modern_Spanish_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairModern_Spanish_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Modern_Spanish_CI_AS] NameValuePair_Modern_Spanish_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Polish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Polish_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairPolish_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Polish_CI_AS] NameValuePair_Polish_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Romanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Romanian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairRomanian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Romanian_CI_AS] NameValuePair_Romanian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Slovak_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Slovak_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSlovak_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Slovak_CI_AS] NameValuePair_Slovak_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Slovenian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Slovenian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSlovenian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Slovenian_CI_AS] NameValuePair_Slovenian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Thai_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Thai_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairThai_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Thai_CI_AS] NameValuePair_Thai_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Turkish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Turkish_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTurkish_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Turkish_CI_AS] NameValuePair_Turkish_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Ukrainian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Ukrainian_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairUkrainian_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Ukrainian_CI_AS] NameValuePair_Ukrainian_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Vietnamese_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Vietnamese_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairVietnamese_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Vietnamese_CI_AS] NameValuePair_Vietnamese_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Azeri_Cyrillic_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Azeri_Cyrillic_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAzeri_Cyrillic_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Azeri_Cyrillic_90_CI_AS] NameValuePair_Azeri_Cyrillic_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Azeri_Latin_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Azeri_Latin_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAzeri_Latin_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Azeri_Latin_90_CI_AS] NameValuePair_Azeri_Latin_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Hong_Kong_Stroke_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS] NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Divehi_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Divehi_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairDivehi_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Divehi_90_CI_AS] NameValuePair_Divehi_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Indic_General_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Indic_General_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairIndic_General_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Indic_General_90_CI_AS] NameValuePair_Indic_General_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Kazakh_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Kazakh_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKazakh_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Kazakh_90_CI_AS] NameValuePair_Kazakh_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Macedonian_FYROM_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Macedonian_FYROM_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairMacedonian_FYROM_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Macedonian_FYROM_90_CI_AS] NameValuePair_Macedonian_FYROM_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Syriac_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Syriac_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSyriac_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Syriac_90_CI_AS] NameValuePair_Syriac_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Tatar_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Tatar_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTatar_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Tatar_90_CI_AS] NameValuePair_Tatar_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Uzbek_Latin_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Uzbek_Latin_90_CI_AS]')) BEGIN PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairUzbek_Latin_90_CI_AS_Value are now being updated with default sampling.' SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Uzbek_Latin_90_CI_AS] NameValuePair_Uzbek_Latin_90_CI_AS_Value' PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding' EXEC (@command) PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done' END RETURN 0