'+OPTIMIZER_WHATIF.sqlC:\Fabiano\Trabalho\WebCasts, Artigos e Palestras\Simple Talk\OPTIMIZER_WHATIF.sql9C:\Users\Fabiano\AppData\Local\Temp\OPTIMIZER_WHATIF.sql0)’žUSE [master] GO /****** Object: Database [TestOptimizer_WhatIF] Script Date: 16-Jan-13 5:06:26 PM ******/ CREATE DATABASE [TestOptimizer_WhatIF] CONTAINMENT = NONE ON PRIMARY ( NAME = N'TestOptimizer_WhatIF', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\TestOptimizer_WhatIF.mdf' , SIZE = 102400KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'TestOptimizer_WhatIF_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\TestOptimizer_WhatIF_log.ldf' , SIZE = 123648KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS GO ALTER DATABASE [TestOptimizer_WhatIF] SET COMPATIBILITY_LEVEL = 110 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [TestOptimizer_WhatIF].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [TestOptimizer_WhatIF] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET ANSI_NULLS OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET ANSI_PADDING OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET ANSI_WARNINGS OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET ARITHABORT OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET AUTO_CLOSE OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [TestOptimizer_WhatIF] SET AUTO_SHRINK OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [TestOptimizer_WhatIF] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [TestOptimizer_WhatIF] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET DISABLE_BROKER GO ALTER DATABASE [TestOptimizer_WhatIF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET TRUSTWORTHY OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [TestOptimizer_WhatIF] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET RECOVERY FULL GO ALTER DATABASE [TestOptimizer_WhatIF] SET MULTI_USER GO ALTER DATABASE [TestOptimizer_WhatIF] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [TestOptimizer_WhatIF] SET DB_CHAINING OFF GO ALTER DATABASE [TestOptimizer_WhatIF] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [TestOptimizer_WhatIF] SET TARGET_RECOVERY_TIME = 0 SECONDS GO EXEC sys.sp_db_vardecimal_storage_format N'TestOptimizer_WhatIF', N'ON' GO USE [TestOptimizer_WhatIF] GO /****** Object: Table [dbo].[TestRunningTotals] Script Date: 16-Jan-13 5:06:26 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TestRunningTotals]( [ID] [int] IDENTITY(1,1) NOT NULL, [ID_Account] [int] NULL, [ColDate] [date] NULL, [ColValue] [float] NULL, CONSTRAINT [PK__TestRunn__3214EC27C9ABDA0E] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Index [ix] Script Date: 16-Jan-13 5:06:26 PM ******/ CREATE UNIQUE NONCLUSTERED INDEX [ix] ON [dbo].[TestRunningTotals] ( [ID_Account] ASC, [ColDate] ASC ) INCLUDE ( [ColValue]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Statistic [_WA_Sys_00000002_0EA330E9] Script Date: 16-Jan-13 5:06:26 PM ******/ CREATE STATISTICS [_WA_Sys_00000002_0EA330E9] ON [dbo].[TestRunningTotals]([ID_Account]) WITH STATS_STREAM = 0x01000000010000000000000000000000F9EC17EE000000003C1A000000000000FC19000000000000380200003800000004000A0000000000000000000000000007000000D81B0A0148A1000004E40500000000005BC4030000000000C518643AC868983B0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C8000000C80000000100000014000000000080408080BC480000000000008040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000381800000000000088180000000000009018000000000000400600000000000057060000000000006E0600000000000085060000000000009C06000000000000B306000000000000CA06000000000000E106000000000000F8060000000000000F0700000000000026070000000000003D0700000000000054070000000000006B0700000000000082070000000000009907000000000000B007000000000000C707000000000000DE07000000000000F5070000000000000C0800000000000023080000000000003A08000000000000510800000000000068080000000000007F080000000000009608000000000000AD08000000000000C408000000000000DB08000000000000F2080000000000000909000000000000200900000000000037090000000000004E0900000000000065090000000000007C090000000000009309000000000000AA09000000000000C109000000000000D809000000000000EF09000000000000060A0000000000001D0A000000000000340A0000000000004B0A000000000000620A000000000000790A000000000000900A000000000000A70A000000000000BE0A000000000000D50A000000000000EC0A000000000000030B0000000000001A0B000000000000310B000000000000480B0000000000005F0B000000000000760B0000000000008D0B000000000000A40B000000000000BB0B000000000000D20B000000000000E90B000000000000000C000000000000170C0000000000002E0C000000000000450C0000000000005C0C000000000000730C0000000000008A0C000000000000A10C000000000000B80C000000000000CF0C000000000000E60C000000000000FD0C000000000000140D0000000000002B0D000000000000420D000000000000590D000000000000700D000000000000870D0000000000009E0D000000000000B50D000000000000CC0D000000000000E30D000000000000FA0D000000000000110E000000000000280E0000000000003F0E000000000000560E0000000000006D0E000000000000840E0000000000009B0E000000000000B20E000000000000C90E000000000000E00E000000000000F70E0000000000000E0F000000000000250F0000000000003C0F000000000000530F0000000000006A0F000000000000810F000000000000980F000000000000AF0F000000000000C60F000000000000DD0F000000000000F40F0000000000000B1000000000000022100000000000003910000000000000501000000000000067100000000000007E100000000000009510000000000000AC10000000000000C310000000000000DA10000000000000F11000000000000008110000000000001F1100000000000036110000000000004D1100000000000064110000000000007B110000000000009211000000000000A911000000000000C011000000000000D711000000000000EE1100000000000005120000000000001C1200000000000033120000000000004A12000000000000611200000000000078120000000000008F12000000000000A612000000000000BD12000000000000D412000000000000EB1200000000000002130000000000001913000000000000301300000000000047130000000000005E1300000000000075130000000000008C13000000000000A313000000000000BA13000000000000D113000000000000E813000000000000FF1300000000000016140000000000002D1400000000000044140000000000005B1400000000000072140000000000008914000000000000A014000000000000B714000000000000CE14000000000000E514000000000000FC1400000000000013150000000000002A15000000000000411500000000000058150000000000006F1500000000000086150000000000009D15000000000000B415000000000000CB15000000000000E215000000000000F915000000000000101600000000000027160000000000003E1600000000000055160000000000006C1600000000000083160000000000009A16000000000000B116000000000000C816000000000000DF16000000000000F6160000000000000D1700000000000024170000000000003B170000000000005217000000000000691700000000000080170000000000009717000000000000AE17000000000000C517000000000000DC17000000000000F3170000000000000A18000000000000211800000000000010001400A362D744000000000000803F0000000004000010001400CBB0E244750CEB44750CEB4402000000040000100014000474DC44000000000000803F0300000004000010001400AFD5E444000000000000803F0400000004000010001400E78BE044000000000000803F0500000004000010001400792CE744000000000000803F0600000004000010001400489DE544000000000000803F07000000040000100014001E42DC44000000000000803F0800000004000010001400B5FCDE44000000000000803F09000000040000100014005C44EB44000000000000803F0A000000040000100014006CACDB44000000000000803F0B00000004000010001400FE4CE244000000000000803F0C00000004000010001400BB23D944000000000000803F0D00000004000010001400ABBBE844000000000000803F0E000000040000100014006A9FDD44000000000000803F0F00000004000010001400181BE244000000000000803F100000000400001000140050D1DD44DC99E744DC99E7441200000004000010001400CBB0E24436A8EB4436A8EB44140000000400001000140074E0D344000000000000803F15000000040000100014009D3BDD44000000000000803F1600000004000010001400160EE444000000000000803F17000000040000100014009714E344000000000000803F1800000004000010001400489DE544000000000000803F19000000040000100014003603DE44000000000000803F1A00000004000010001400FE4CE244000000000000803F1B0000000400001000140050D1DD44000000000000803F1C00000004000010001400DF57E844000000000000803F1D000000040000100014006EB9D944000000000000803F1E00000004000010001400B3EFE044000000000000803F1F0000000400001000140012F4E744000000000000803F20000000040000100014009507E544000000000000803F2100000004000010001400CDBDE044000000000000803F220000000400001000140030DCE344000000000000803F2300000004000010001400A9AEEA44000000000000803F24000000040000100014004CB7E144000000000000803F2500000004000010001400857ADB44000000000000803F26000000040000100014000681DA44000000000000803F27000000040000100014009714E344000000000000803F2800000004000010001400EDB2DA44000000000000803F29000000040000100014009B2EDF44000000000000803F2A00000004000010001400B3EFE044000000000000803F2B000000040000100014009714E344000000000000803F2C000000040000100014009B2EDF44000000000000803F2D000000040000100014000681DA44000000000000803F2E000000040000100014003603DE44000000000000803F2F00000004000010001400248EEF44000000000000803F3000000004000010001400FC3FE444000000000000803F31000000040000100014008160DF44000000000000803F32000000040000100014006CACDB442D5BE4442D5BE44434000000040000100014000EDAEB44000000000000803F3500000004000010001400CBB0E244000000000000803F3600000004000010001400EDB2DA44000000000000803F37000000040000100014008160DF44000000000000803F3800000004000010001400EBA5DC44D92AE544D92AE5443A00000004000010001400088ED844000000000000803F3B00000004000010001400E57EE244000000000000803F3C000000040000100014006685E144000000000000803F3D00000004000010001400A155D944000000000000803F3E00000004000010001400005AE044000000000000803F3F000000040000100014006EB9D944000000000000803F4000000004000010001400D1D7DC44000000000000803F4100000004000010001400F618EA44000000000000803F4200000004000010001400BB23D944000000000000803F4300000004000010001400FE4CE244000000000000803F44000000040000100014006892DF44000000000000803F4500000004000010001400A362D744000000000000803F46000000040000100014007F53E144000000000000803F4700000004000010001400E57EE244000000000000803F48000000040000100014003603DE44000000000000803F4900000004000010001400D7FED644000000000000803F4A00000004000010001400181BE244000000000000803F4B00000004000010001400626BE544000000000000803F4C000000040000100014000474DC44000000000000803F4D000000040000100014008FBBD144000000000000803F4E000000040000100014002ECFE544000000000000803F4F000000040000100014006892DF44000000000000803F50000000040000100014001E42DC44000000000000803F51000000040000100014003603DE44000000000000803F5200000004000010001400B3EFE044000000000000803F53000000040000100014004690E744000000000000803F5400000004000010001400E164E644000000000000803F5500000004000010001400EBA5DC44000000000000803F5600000004000010001400BD30D744000000000000803F5700000004000010001400C37CEA44000000000000803F58000000040000100014008160DF44000000000000803F590000000400001000140050D1DD44000000000000803F5A00000004000010001400EDB2DA44000000000000803F5B000000040000100014001A28E044000000000000803F5C00000004000010001400D3E4DA44000000000000803F5D000000040000100014002CC2E744000000000000803F5E000000040000100014004CB7E144000000000000803F5F00000004000010001400B5FCDE44000000000000803F6000000004000010001400D5F1D844000000000000803F6100000004000010001400E78BE044000000000000803F6200000004000010001400B5FCDE44000000000000803F6300000004000010001400160EE444CCABEC44CCABEC446500000004000010001400A362D744000000000000803F6600000004000010001400CFCADE44000000000000803F6700000004000010001400BB23D944000000000000803F68000000040000100014009714E344000000000000803F69000000040000100014000267DE44000000000000803F6A00000004000010001400E78BE044000000000000803F6B000000040000100014000681DA44000000000000803F6C000000040000100014008160DF445DD1E8445DD1E8446E000000040000100014004EC4DF44000000000000803F6F00000004000010001400836DDD44000000000000803F7000000004000010001400E78BE044000000000000803F71000000040000100014008160DF44000000000000803F7200000004000010001400B916DB44000000000000803F7300000004000010001400E78BE044000000000000803F74000000040000100014003A1DDA44000000000000803F7500000004000010001400C9A3E444000000000000803F76000000040000100014003603DE44000000000000803F7700000004000010001400225CD844000000000000803F78000000040000100014009714E344000000000000803F7900000004000010001400005AE044000000000000803F7A00000004000010001400D7FED644000000000000803F7B00000004000010001400A9AEEA44000000000000803F7C00000004000010001400ABBBE844000000000000803F7D00000004000010001400CFCADE44000000000000803F7E00000004000010001400FE4CE244000000000000803F7F00000004000010001400BF3DD544000000000000803F8000000004000010001400E371E444000000000000803F8100000004000010001400B5FCDE44000000000000803F820000000400001000140091EDE844000000000000803F83000000040000100014004CB7E144000000000000803F84000000040000100014000EDAEB44000000000000803F8500000004000010001400857ADB44000000000000803F86000000040000100014007D46E3440B10EC440B10EC448800000004000010001400B916DB44000000000000803F89000000040000100014001C35DE44000000000000803F8A000000040000100014004AAAE344000000000000803F8B000000040000100014009D3BDD44000000000000803F8C00000004000010001400DB3DEC44000000000000803F8D000000040000100014007F53E144000000000000803F8E00000004000010001400B1E2E244000000000000803F8F00000004000010001400B5FCDE44000000000000803F9000000004000010001400DD25D144000000000000803F91000000040000100014009921E144000000000000803F92000000040000100014001C35DE44000000000000803F9300000004000010001400AFD5E444000000000000803F9400000004000010001400B3EFE044000000000000803F95000000040000100014001C35DE44000000000000803F9600000004000010001400BB23D944000000000000803F9700000004000010001400B916DB44000000000000803F98000000040000100014001401E644000000000000803F9900000004000010001400CDBDE044B470EA44B470EA449B00000004000010001400FE4CE244000000000000803F9C000000040000100014007D46E344000000000000803F9D0000000400001000140091EDE844000000000000803F9E0000000400001000140034F6DF44000000000000803F9F00000004000010001400E57EE244000000000000803FA0000000040000100014008787D944000000000000803FA10000000400001000140050D1DD44000000000000803FA20000000400001000140034F6DF443339E9443339E944A400000004000010001400E998DE44B201E844B201E844A600000004000010001400FC3FE444A213ED44A213ED44A8000000040000100014004483E944000000000000803FA9000000040000100014001A28E044000000000000803FAA0000000400001000140054EBD944000000000000803FAB00000004000010001400DD4AEA44000000000000803FAC00000004000010001400E57EE244000000000000803FAD00000004000010001400F5E6D244000000000000803FAE000000040000100014007F53E144000000000000803FAF000000040000100014003810DC44000000000000803FB0000000040000100014007D46E344000000000000803FB100000004000010001400160EE444000000000000803FB200000004000010001400005AE044000000000000803FB300000004000010001400B5FCDE44000000000000803FB400000004000010001400626BE544000000000000803FB500000004000010001400160EE444000000000000803FB60000000400001000140050D1DD44000000000000803FB700000004000010001400181BE244000000000000803FB8000000040000100014003603DE44000000000000803FB900000004000010001400005AE044000000000000803FBA00000004000010001400E57EE244750CEB44750CEB44BC000000040000100014007D46E344000000000000803FBD000000040000100014006685E144000000000000803FBE00000004000010001400D1D7DC44000000000000803FBF000000040000100014000267DE44000000000000803FC0000000040000100014001E42DC44000000000000803FC1000000040000100014000681DA446DBFE3446DBFE344C300000004000010001400A7A1EC44000000000000803FC4000000040000100014006A9FDD440632E7440632E744C600000004000010001400EBA5DC44000000000000803FC700000004000010001400E998DE44000000000000803FC8000000040000100014006478E344000000000000803FC900000004000010001400B916DB44000000000000803FCA000000040000100014009921E144000000000000803FCB00000004000010001400225CD844000000000000803FCC00000004000010001400E57EE244000000000000803FCD000000040000100014004EC4DF44000000000000803FCE00000004000010001400CFCADE44000000000000803FCF000000040000100014006478E344000000000000803FD0000000040000100014007F53E144000000000000803FD100000004000010001400489DE544000000000000803FD200000004000010001400B709DD44000000000000803FD3000000040000100014003A1DDA44000000000000803FD4000000040000100014009F48DB44000000000000803FD500000004000010001400B3A5AE44000000000000803FD60000000400000100000044100A0148A100000000000080841E4120A1070000000000C800000000000000190D733F00000000000000000000000000000000000000000000000000000000C0D1FB403693B54BE72CC53F04E4050000000000 GO /****** Object: Statistic [_WA_Sys_00000003_0EA330E9] Script Date: 16-Jan-13 5:06:26 PM ******/ CREATE STATISTICS [_WA_Sys_00000003_0EA330E9] ON [dbo].[TestRunningTotals]([ColDate]) WITH STATS_STREAM = 0x01000000010000000000000000000000189541DC000000001A0C000000000000DA0B000000000000280200002800000003000A0000000000000000000200000007000000540C0A0148A1000020A1070000000000EAD90400000000009B905D3C64757339000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000059000000590000000100000013000000000040400024F44800000000000040400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000006E0A000000000000760A000000000000C802000000000000DE02000000000000F4020000000000000A03000000000000200300000000000036030000000000004C03000000000000620300000000000078030000000000008E03000000000000A403000000000000BA03000000000000D003000000000000E603000000000000FC03000000000000120400000000000028040000000000003E0400000000000054040000000000006A0400000000000080040000000000009604000000000000AC04000000000000C204000000000000D804000000000000EE0400000000000004050000000000001A05000000000000300500000000000046050000000000005C05000000000000720500000000000088050000000000009E05000000000000B405000000000000CA05000000000000E005000000000000F6050000000000000C06000000000000220600000000000038060000000000004E0600000000000064060000000000007A060000000000009006000000000000A606000000000000BC06000000000000D206000000000000E806000000000000FE0600000000000014070000000000002A07000000000000400700000000000056070000000000006C0700000000000082070000000000009807000000000000AE07000000000000C407000000000000DA07000000000000F00700000000000006080000000000001C08000000000000320800000000000048080000000000005E0800000000000074080000000000008A08000000000000A008000000000000B608000000000000CC08000000000000E208000000000000F8080000000000000E0900000000000024090000000000003A09000000000000500900000000000066090000000000007C090000000000009209000000000000A809000000000000BE09000000000000D409000000000000EA09000000000000000A000000000000160A0000000000002C0A000000000000420A000000000000580A0000000000001000130066E97A42000000000000803F402E0B0400001000130037E9B5428A8104457183DE42542E0B0400001000130074DD0643AB6CB744EBD3F342612E0B04000010001300AAD71143C2D2484595D9E4427E2E0B040000100013001F691343EEBFA145119AEA42AB2E0B0400001000130040862143C5D48845E600EC42D12E0B04000010001300220CB9424CE29C44BE3EFA42DC2E0B04000010001300FE4B05435EEF9945579AEF42062F0B04000010001300B517A3426D390945D16FE6421A2F0B04000010001300E96E0843D775CC445D71D9422A2F0B040000100013000A8C1643E23920459360E842412F0B0400001000130037E9B5429DC8B94480F8E3424F2F0B04000010001300F751BF42D0C0E944A80FE942602F0B040000100013006A401B434767F24490AFF142712F0B040000100013004CC6B2420FE9A644750AF2427D2F0B040000100013000A8C9642C848F944A7EDE9428F2F0B0400001000130074DD0643E4DF91441CAFE8429A2F0B040000100013001F69134311AC34451497E642B42F0B040000100013007BC6F742CF3C0E45F6DAEE42C82F0B04000010001300E0D19C4225A9C6459765E24201300B040000100013005E000A43DFD0A044FD33E9420D300B04000010001300E0D11C431DD7C745B8BDE34246300B040000100013007923D24216054945EF12E54263300B04000010001300BFB40E43FBAF0F461621EB42B2300B04000010001300B8BAC8420F334A4644F8EE421F310B040000100013004CC6B2421EBB8B45CBA9EA4246310B04000010001300E0D19C42B6A73545B7EDDE4261310B040000100013001F691343FF5414450AA3EC4276310B04000010001300F751BF4227B67745F783EF4298310B04000010001300AAD71143EBB190446FCDE642A3310B040000100013000C2FBC42A7303F46016AE8420D320B04000010001300E274C2423397E744BA4BF6421D320B04000010001300E96E0843C72B5D467565E74298320B040000100013001F6913436F73C1443F6DDC42A7320B0400001000130095FA1443E30C99457425E342D3320B0400001000130066E9FA422213C044BAB0EB42E1320B04000010001300CD97C54200BC53451E33E14200330B04000010001300D4910B43186117458A7FF14215330B04000010001300A3DDCB4261EF0C46C4B4E34265330B0400001000130034461043AAD71046B83DE442B7330B0400001000130013290243C06AA9452343F042E5330B0400001000130095FA14437765094643C0E64232340B040000100013001F691343E636E6447E08D84244340B04000010001300E96E0843FD52D44540AAE54280340B040000100013007923D242523C114656DCE442D2340B040000100013000A8C1643D429E944ECF7F742E2340B04000010001300CD97C5426F840C4686EDE84230350B040000100013004CC6B2428C441245CC3BDE4246350B04000010001300AAD711430A6EFC444FE1EC4258350B04000010001300FE4B0543A8D6304584B2E14272350B0400001000130037E9B542C2C1FD450AB4EA42B8350B0400001000130034461043046F7645B145E742DB350B040000100013004E69D8424CB515458D66FB42EF350B040000100013001F699342CDF10A46365EE3423E360B04000010001300510CFE42275098450E14ED4268360B040000100013000FD2E1423AD59F4559D2E74295360B04000010001300EEB453438BBBBC44DB96E742A3360B0400001000130095FA144386AC4B453219E842C0360B040000100013009E9700439D7E9645831AF042E9360B0400001000130049230D43EE1A904605D5E84288370B0400001000130013290243D31D9845A8C2E142B4370B04000010001300E274C242A1428445F81DDE42DB370B040000100013004CC6B242819DDA44A319F942EA370B040000100013000A8C1643427A17462CC9EB423D380B040000100013007F1D1843AD2FC544D6AEE0424C380B04000010001300E274C2425974EF44DEBEEE425D380B040000100013005E000A43CE1C454614D2E642CB380B040000100013008E00CF422711E645756AE5420C390B040000100013005E000A438FAD11456556DD4222390B040000100013007680AC4243FE72450BF4EA4244390B04000010001300510CFE429B4FCF45341CE8427E390B040000100013001F691343600D16463491E942D1390B0400001000130055631E43DDCFC0450EA2EC42063A0B04000010001300E274C2420A9012457FAEDE421C3A0B0400001000130066E9FA42FD369845E3ECEC42463A0B0400001000130089BA03437FBB634684E1E442C63A0B0400001000130049230D435068B846E7C3E642933B0B040000100013009E9700433FE410458624DC42A93B0B040000100013007923D24274E9F145ECEAE942EC3B0B04000010001300AAD71143D52A4946666DE9425B3C0B04000010001300B8BAC842400D7E46514AE942E73C0B04000010001300F5AE194342C43A45A1B6DC42033D0B040000100013000C2FBC424FA60A46E5F5EB424F3D0B04000010001300E517E842FB7E7B463A4BE542DC3D0B040000100013007923D242C9A4474555A9DB42FA3D0B040000100013005E000A43FC271A468FF4EF424D3E0B040000100013005E000A438C4BA14631C1E442023F0B04000010001300CD97C542E99F654386AAE442053F0B0400001000130089BA8342021BA63E162EE842063F0B04000020A1070000000000 GO /****** Object: Statistic [ix] Script Date: 16-Jan-13 5:06:26 PM ******/ UPDATE STATISTICS [dbo].[TestRunningTotals]([ix]) WITH STATS_STREAM = 0x010000000300000000000000000000002BBC5B2D00000000141A000000000000A419000000000000380200003800000004000A00000000000000000002000000280200002800000003000A00000000000000000000000000380300003800000004000A000000000000000000000000000700000010210A0148A1000004E405000000000004E40500000000008593113AC868983B70D52D3670D52D36000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C8000000C80000000300000014000000000030418080BC48000000000000804000004040000080400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001100000000000000000000000000000038180000000000004018000000000000400600000000000057060000000000006E0600000000000085060000000000009C06000000000000B306000000000000CA06000000000000E106000000000000F8060000000000000F0700000000000026070000000000003D0700000000000054070000000000006B0700000000000082070000000000009907000000000000B007000000000000C707000000000000DE07000000000000F5070000000000000C0800000000000023080000000000003A08000000000000510800000000000068080000000000007F080000000000009608000000000000AD08000000000000C408000000000000DB08000000000000F2080000000000000909000000000000200900000000000037090000000000004E0900000000000065090000000000007C090000000000009309000000000000AA09000000000000C109000000000000D809000000000000EF09000000000000060A0000000000001D0A000000000000340A0000000000004B0A000000000000620A000000000000790A000000000000900A000000000000A70A000000000000BE0A000000000000D50A000000000000EC0A000000000000030B0000000000001A0B000000000000310B000000000000480B0000000000005F0B000000000000760B0000000000008D0B000000000000A40B000000000000BB0B000000000000D20B000000000000E90B000000000000000C000000000000170C0000000000002E0C000000000000450C0000000000005C0C000000000000730C0000000000008A0C000000000000A10C000000000000B80C000000000000CF0C000000000000E60C000000000000FD0C000000000000140D0000000000002B0D000000000000420D000000000000590D000000000000700D000000000000870D0000000000009E0D000000000000B50D000000000000CC0D000000000000E30D000000000000FA0D000000000000110E000000000000280E0000000000003F0E000000000000560E0000000000006D0E000000000000840E0000000000009B0E000000000000B20E000000000000C90E000000000000E00E000000000000F70E0000000000000E0F000000000000250F0000000000003C0F000000000000530F0000000000006A0F000000000000810F000000000000980F000000000000AF0F000000000000C60F000000000000DD0F000000000000F40F0000000000000B1000000000000022100000000000003910000000000000501000000000000067100000000000007E100000000000009510000000000000AC10000000000000C310000000000000DA10000000000000F11000000000000008110000000000001F1100000000000036110000000000004D1100000000000064110000000000007B110000000000009211000000000000A911000000000000C011000000000000D711000000000000EE1100000000000005120000000000001C1200000000000033120000000000004A12000000000000611200000000000078120000000000008F12000000000000A612000000000000BD12000000000000D412000000000000EB1200000000000002130000000000001913000000000000301300000000000047130000000000005E1300000000000075130000000000008C13000000000000A313000000000000BA13000000000000D113000000000000E813000000000000FF1300000000000016140000000000002D1400000000000044140000000000005B1400000000000072140000000000008914000000000000A014000000000000B714000000000000CE14000000000000E514000000000000FC1400000000000013150000000000002A15000000000000411500000000000058150000000000006F1500000000000086150000000000009D15000000000000B415000000000000CB15000000000000E215000000000000F915000000000000101600000000000027160000000000003E1600000000000055160000000000006C1600000000000083160000000000009A16000000000000B116000000000000C816000000000000DF16000000000000F6160000000000000D1700000000000024170000000000003B170000000000005217000000000000691700000000000080170000000000009717000000000000AE17000000000000C517000000000000DC17000000000000F3170000000000000A180000000000002118000000000000100014000040DA44000000000000803F00000000040000100014000020E344000000000000803F01000000040000100014000080DB44000000000000803F02000000040000100014000040DF44000000000000803F030000000400001000140000C0E144000000000000803F04000000040000100014000060DB44000000000000803F05000000040000100014000060E544000000000000803F060000000400001000140000C0E144000000000000803F07000000040000100014000020E144000000000000803F080000000400001000140000C0E344000000000000803F090000000400001000140000C0EA44000000000000803F0A000000040000100014000020DD44000000000000803F0B000000040000100014000020EB44000000000000803F0C000000040000100014000040DC44000000000000803F0D0000000400001000140000E0E444000000000000803F0E000000040000100014000000E344000000000000803F0F000000040000100014000040E044000000000000803F10000000040000100014000000DB44000000000000803F11000000040000100014000040E544000000000000803F120000000400001000140000E0DD44000000000000803F13000000040000100014000000DF44000000000000803F14000000040000100014000000DA44000000000000803F150000000400001000140000C0DE44000000000000803F16000000040000100014000080E544000000000000803F17000000040000100014000040DC44000000000000803F180000000400001000140000A0E644000000000000803F19000000040000100014000080DE44000000000000803F1A000000040000100014000020E14400C0E04400C0E0441C0000000400001000140000E0E144000000000000803F1D0000000400001000140000E0E244000000000000803F1E0000000400001000140000C0DA44000000000000803F1F000000040000100014000000E244000000000000803F200000000400001000140000A0E344000000000000803F21000000040000100014000020DF44000000000000803F220000000400001000140000A0E444000000000000803F230000000400001000140000A0E944000000000000803F240000000400001000140000C0DC44000000000000803F25000000040000100014000080DF44000000000000803F26000000040000100014000020E044000000000000803F27000000040000100014000000E344000000000000803F28000000040000100014000020E044000000000000803F290000000400001000140000A0E244000000000000803F2A0000000400001000140000A0DF44000000000000803F2B000000040000100014000080E44400A0E44400A0E4442D000000040000100014000080DD44000000000000803F2E0000000400001000140000E0DB44000000000000803F2F000000040000100014000040E744000000000000803F300000000400001000140000A0E244000000000000803F31000000040000100014000080DE44000000000000803F320000000400001000140000C0DD44000000000000803F33000000040000100014000080DE44000000000000803F34000000040000100014000000EC44000000000000803F35000000040000100014000040E044000000000000803F36000000040000100014000040DD44000000000000803F37000000040000100014000080DF44000000000000803F380000000400001000140000C0DB44000000000000803F39000000040000100014000080DF44000000000000803F3A000000040000100014000080DE44000000000000803F3B000000040000100014000080DF44000000000000803F3C000000040000100014000080E444000000000000803F3D0000000400001000140000E0DB44000000000000803F3E0000000400001000140000C0DF44000000000000803F3F0000000400001000140000E0DC44000000000000803F40000000040000100014000060E444000000000000803F410000000400001000140000A0DF44000000000000803F42000000040000100014000060DE44000000000000803F430000000400001000140000A0E2440020E3440020E344450000000400001000140000A0DD440080DD440080DD44470000000400001000140000C0E344000000000000803F48000000040000100014000020E544000000000000803F490000000400001000140000A0DA44000000000000803F4A0000000400001000140000A0E044000000000000803F4B0000000400001000140000A0E244000000000000803F4C000000040000100014000060DE44000000000000803F4D000000040000100014000060DB44000000000000803F4E0000000400001000140000A0E5440020E5440020E544500000000400001000140000C0DC44000000000000803F510000000400001000140000C0D744000000000000803F52000000040000100014000040D944000000000000803F530000000400001000140000A0E644000000000000803F540000000400001000140000C0E844000000000000803F55000000040000100014000080DF44000000000000803F560000000400001000140000A0E144000000000000803F57000000040000100014000040E944000000000000803F58000000040000100014000040DF44000000000000803F590000000400001000140000E0DA44000000000000803F5A0000000400001000140000C0DF44000000000000803F5B000000040000100014000080DE44000000000000803F5C000000040000100014000000D744000000000000803F5D000000040000100014000080EC44000000000000803F5E0000000400001000140000A0DD44000000000000803F5F000000040000100014000020DB44000000000000803F60000000040000100014000020D944000000000000803F61000000040000100014000040E444000000000000803F62000000040000100014000080E844000000000000803F63000000040000100014000040E444000000000000803F64000000040000100014000040E244000000000000803F650000000400001000140000A0D744000000000000803F66000000040000100014000080E044000000000000803F670000000400001000140000E0DF44000000000000803F68000000040000100014000000E2440080E2440080E2446A000000040000100014000020E344000000000000803F6B000000040000100014000060D944000000000000803F6C000000040000100014000000DC44000000000000803F6D000000040000100014000080DF44000000000000803F6E0000000400001000140000E0DD44000000000000803F6F000000040000100014000060E144000000000000803F700000000400001000140000C0E244000000000000803F710000000400001000140000E0E044000000000000803F720000000400001000140000E0DF44000000000000803F730000000400001000140000A0E144000000000000803F74000000040000100014000060DE44000000000000803F750000000400001000140000A0E24400E0E24400E0E244770000000400001000140000E0D844000000000000803F78000000040000100014000060E444000000000000803F790000000400001000140000A0DD44000000000000803F7A000000040000100014000080DC44000000000000803F7B0000000400001000140000E0E544000000000000803F7C000000040000100014000020EA44000000000000803F7D000000040000100014000040E044000000000000803F7E000000040000100014000040E944000000000000803F7F000000040000100014000000DA44000000000000803F800000000400001000140000E0E344000000000000803F81000000040000100014000020E344000000000000803F82000000040000100014000040E544000000000000803F830000000400001000140000A0DE44000000000000803F840000000400001000140000C0E1440080E1440080E14486000000040000100014000060DF440020DF440020DF4488000000040000100014000080DB44000000000000803F890000000400001000140000E0E244000000000000803F8A000000040000100014000000E644000000000000803F8B000000040000100014000000DA44000000000000803F8C000000040000100014000080EA44000000000000803F8D000000040000100014000020E044000000000000803F8E0000000400001000140000E0E944000000000000803F8F000000040000100014000000E044000000000000803F900000000400001000140000C0D544000000000000803F910000000400001000140000E0DC44000000000000803F920000000400001000140000C0DF44000000000000803F93000000040000100014000080E744000000000000803F94000000040000100014000040E444000000000000803F950000000400001000140000A0DE44000000000000803F96000000040000100014000020D844000000000000803F97000000040000100014000080E044000000000000803F98000000040000100014000000EA44000000000000803F990000000400001000140000A0E244000000000000803F9A000000040000100014000000DF44000000000000803F9B0000000400001000140000C0DD44000000000000803F9C000000040000100014000000E244000000000000803F9D000000040000100014000040E644000000000000803F9E000000040000100014000060DF44000000000000803F9F000000040000100014000020DD44000000000000803FA00000000400001000140000A0DA44000000000000803FA1000000040000100014000060E04400C0DF4400C0DF44A3000000040000100014000080DE44000000000000803FA40000000400001000140000C0DF44000000000000803FA5000000040000100014000040DE44000000000000803FA6000000040000100014000040E244000000000000803FA70000000400001000140000C0E1440000E2440000E244A9000000040000100014000080DF44000000000000803FAA0000000400001000140000E0DB44000000000000803FAB0000000400001000140000C0E944000000000000803FAC0000000400001000140000C0E044000000000000803FAD000000040000100014000040DB44000000000000803FAE0000000400001000140000E0E644000000000000803FAF000000040000100014000040DE440000DE440000DE44B10000000400001000140000C0E144000000000000803FB2000000040000100014000060E244000000000000803FB3000000040000100014000060DD44000000000000803FB4000000040000100014000060E3440060E3440060E344B60000000400001000140000A0DC44000000000000803FB70000000400001000140000E0E544000000000000803FB8000000040000100014000020DD44000000000000803FB9000000040000100014000020DE44000000000000803FBA000000040000100014000000E644000000000000803FBB000000040000100014000080E244000000000000803FBC000000040000100014000060E344000000000000803FBD0000000400001000140000A0DE44000000000000803FBE000000040000100014000060DB44000000000000803FBF000000040000100014000080E044000000000000803FC0000000040000100014000040DF4400E0DE4400E0DE44C2000000040000100014000000DC44000000000000803FC3000000040000100014000060E844000000000000803FC40000000400001000140000C0DF44000000000000803FC5000000040000100014000020DE44000000000000803FC60000000400001000140000C0DC440040DD440040DD44C80000000400001000140000C0E044000000000000803FC90000000400001000140000A0DF44000000000000803FCA000000040000100014000040E244000000000000803FCB0000000400001000140000C0E744000000000000803FCC000000040000100014000040E444000000000000803FCD0000000400001000140000C0E044000000000000803FCE0000000400001000140000C0E144000000000000803FCF0000000400001000140000E0E544000000000000803FD00000000400001000140000C0E144000000000000803FD10000000400001000140000E0E444000000000000803FD20000000400001000140000A0DB44000000000000803FD3000000040000100014000040DD44000000000000803FD4000000040000100014000000E044000000000000803FD5000000040000100014000040AE44000000000000803FD600000004000004E4050000000000, ROWCOUNT = 386052, PAGECOUNT = 1198 GO /****** Object: Statistic [PK__TestRunn__3214EC27C9ABDA0E] Script Date: 16-Jan-13 5:06:26 PM ******/ UPDATE STATISTICS [dbo].[TestRunningTotals]([PK__TestRunn__3214EC27C9ABDA0E]) WITH STATS_STREAM = 0x010000000100000000000000000000006FC962C000000000400000000000000000000000000000003803FFFF3800000004000A00000000000000000000000000, ROWCOUNT = 386052, PAGECOUNT