Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Creates a database with an empty Users table, with about 1,000 indexes, each on a partition scheme with about 1,000 partitions
CREATE DATABASE MuchoPartitions;
GO
USE MuchoPartitions;
GO
CREATE TABLE [dbo].[Users](
[Id] [int] IDENTITY(1,1) NOT NULL,
[AboutMe] [nvarchar](max) NULL,
[Age] [int] NULL,
[CreationDate] [datetime] NOT NULL,
[DisplayName] [nvarchar](40) NOT NULL,
[DownVotes] [int] NOT NULL,
[EmailHash] [nvarchar](40) NULL,
[LastAccessDate] [datetime] NOT NULL,
[Location] [nvarchar](100) NULL,
[Reputation] [int] NOT NULL,
[UpVotes] [int] NOT NULL,
[Views] [int] NOT NULL,
[WebsiteUrl] [nvarchar](200) NULL,
[AccountId] [int] NULL,
CONSTRAINT [PK_Users_Id] 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] TEXTIMAGE_ON [PRIMARY]
GO
/* Build a partition function
;WITH
Pass0 as (select 1 as C union all select 1), --2 rows
Pass1 as (select 1 as C from Pass0 as A, Pass0 as B),--4 rows
Pass2 as (select 1 as C from Pass1 as A, Pass1 as B),--16 rows
Pass3 as (select 1 as C from Pass2 as A, Pass2 as B),--256 rows
Pass4 as (select 1 as C from Pass3 as A, Pass3 as B),--65536 rows
Tally as (select row_number() over(order by C) as Number from Pass4)
SELECT 'DECLARE @StartDay DATE = ''2000-01-01''; CREATE PARTITION FUNCTION pfMonthly (DATETIME) AS RANGE RIGHT FOR VALUES (@StartDay, ' AS ScriptLine
UNION ALL
SELECT ' DATEADD(MM, ' + CAST(Number AS VARCHAR(10)) + ', @StartDay ), '
from Tally
where Number <= 997
UNION ALL
SELECT ' DATEADD(MM, 998, @StartDay ))';
GO
*/
DECLARE @StartDay DATE = '2000-01-01'; CREATE PARTITION FUNCTION pfMonthly (DATETIME) AS RANGE RIGHT FOR VALUES (@StartDay,
DATEADD(MM, 1, @StartDay ),
DATEADD(MM, 2, @StartDay ),
DATEADD(MM, 3, @StartDay ),
DATEADD(MM, 4, @StartDay ),
DATEADD(MM, 5, @StartDay ),
DATEADD(MM, 6, @StartDay ),
DATEADD(MM, 7, @StartDay ),
DATEADD(MM, 8, @StartDay ),
DATEADD(MM, 9, @StartDay ),
DATEADD(MM, 10, @StartDay ),
DATEADD(MM, 11, @StartDay ),
DATEADD(MM, 12, @StartDay ),
DATEADD(MM, 13, @StartDay ),
DATEADD(MM, 14, @StartDay ),
DATEADD(MM, 15, @StartDay ),
DATEADD(MM, 16, @StartDay ),
DATEADD(MM, 17, @StartDay ),
DATEADD(MM, 18, @StartDay ),
DATEADD(MM, 19, @StartDay ),
DATEADD(MM, 20, @StartDay ),
DATEADD(MM, 21, @StartDay ),
DATEADD(MM, 22, @StartDay ),
DATEADD(MM, 23, @StartDay ),
DATEADD(MM, 24, @StartDay ),
DATEADD(MM, 25, @StartDay ),
DATEADD(MM, 26, @StartDay ),
DATEADD(MM, 27, @StartDay ),
DATEADD(MM, 28, @StartDay ),
DATEADD(MM, 29, @StartDay ),
DATEADD(MM, 30, @StartDay ),
DATEADD(MM, 31, @StartDay ),
DATEADD(MM, 32, @StartDay ),
DATEADD(MM, 33, @StartDay ),
DATEADD(MM, 34, @StartDay ),
DATEADD(MM, 35, @StartDay ),
DATEADD(MM, 36, @StartDay ),
DATEADD(MM, 37, @StartDay ),
DATEADD(MM, 38, @StartDay ),
DATEADD(MM, 39, @StartDay ),
DATEADD(MM, 40, @StartDay ),
DATEADD(MM, 41, @StartDay ),
DATEADD(MM, 42, @StartDay ),
DATEADD(MM, 43, @StartDay ),
DATEADD(MM, 44, @StartDay ),
DATEADD(MM, 45, @StartDay ),
DATEADD(MM, 46, @StartDay ),
DATEADD(MM, 47, @StartDay ),
DATEADD(MM, 48, @StartDay ),
DATEADD(MM, 49, @StartDay ),
DATEADD(MM, 50, @StartDay ),
DATEADD(MM, 51, @StartDay ),
DATEADD(MM, 52, @StartDay ),
DATEADD(MM, 53, @StartDay ),
DATEADD(MM, 54, @StartDay ),
DATEADD(MM, 55, @StartDay ),
DATEADD(MM, 56, @StartDay ),
DATEADD(MM, 57, @StartDay ),
DATEADD(MM, 58, @StartDay ),
DATEADD(MM, 59, @StartDay ),
DATEADD(MM, 60, @StartDay ),
DATEADD(MM, 61, @StartDay ),
DATEADD(MM, 62, @StartDay ),
DATEADD(MM, 63, @StartDay ),
DATEADD(MM, 64, @StartDay ),
DATEADD(MM, 65, @StartDay ),
DATEADD(MM, 66, @StartDay ),
DATEADD(MM, 67, @StartDay ),
DATEADD(MM, 68, @StartDay ),
DATEADD(MM, 69, @StartDay ),
DATEADD(MM, 70, @StartDay ),
DATEADD(MM, 71, @StartDay ),
DATEADD(MM, 72, @StartDay ),
DATEADD(MM, 73, @StartDay ),
DATEADD(MM, 74, @StartDay ),
DATEADD(MM, 75, @StartDay ),
DATEADD(MM, 76, @StartDay ),
DATEADD(MM, 77, @StartDay ),
DATEADD(MM, 78, @StartDay ),
DATEADD(MM, 79, @StartDay ),
DATEADD(MM, 80, @StartDay ),
DATEADD(MM, 81, @StartDay ),
DATEADD(MM, 82, @StartDay ),
DATEADD(MM, 83, @StartDay ),
DATEADD(MM, 84, @StartDay ),
DATEADD(MM, 85, @StartDay ),
DATEADD(MM, 86, @StartDay ),
DATEADD(MM, 87, @StartDay ),
DATEADD(MM, 88, @StartDay ),
DATEADD(MM, 89, @StartDay ),
DATEADD(MM, 90, @StartDay ),
DATEADD(MM, 91, @StartDay ),
DATEADD(MM, 92, @StartDay ),
DATEADD(MM, 93, @StartDay ),
DATEADD(MM, 94, @StartDay ),
DATEADD(MM, 95, @StartDay ),
DATEADD(MM, 96, @StartDay ),
DATEADD(MM, 97, @StartDay ),
DATEADD(MM, 98, @StartDay ),
DATEADD(MM, 99, @StartDay ),
DATEADD(MM, 100, @StartDay ),
DATEADD(MM, 101, @StartDay ),
DATEADD(MM, 102, @StartDay ),
DATEADD(MM, 103, @StartDay ),
DATEADD(MM, 104, @StartDay ),
DATEADD(MM, 105, @StartDay ),
DATEADD(MM, 106, @StartDay ),
DATEADD(MM, 107, @StartDay ),
DATEADD(MM, 108, @StartDay ),
DATEADD(MM, 109, @StartDay ),
DATEADD(MM, 110, @StartDay ),
DATEADD(MM, 111, @StartDay ),
DATEADD(MM, 112, @StartDay ),
DATEADD(MM, 113, @StartDay ),
DATEADD(MM, 114, @StartDay ),
DATEADD(MM, 115, @StartDay ),
DATEADD(MM, 116, @StartDay ),
DATEADD(MM, 117, @StartDay ),
DATEADD(MM, 118, @StartDay ),
DATEADD(MM, 119, @StartDay ),
DATEADD(MM, 120, @StartDay ),
DATEADD(MM, 121, @StartDay ),
DATEADD(MM, 122, @StartDay ),
DATEADD(MM, 123, @StartDay ),
DATEADD(MM, 124, @StartDay ),
DATEADD(MM, 125, @StartDay ),
DATEADD(MM, 126, @StartDay ),
DATEADD(MM, 127, @StartDay ),
DATEADD(MM, 128, @StartDay ),
DATEADD(MM, 129, @StartDay ),
DATEADD(MM, 130, @StartDay ),
DATEADD(MM, 131, @StartDay ),
DATEADD(MM, 132, @StartDay ),
DATEADD(MM, 133, @StartDay ),
DATEADD(MM, 134, @StartDay ),
DATEADD(MM, 135, @StartDay ),
DATEADD(MM, 136, @StartDay ),
DATEADD(MM, 137, @StartDay ),
DATEADD(MM, 138, @StartDay ),
DATEADD(MM, 139, @StartDay ),
DATEADD(MM, 140, @StartDay ),
DATEADD(MM, 141, @StartDay ),
DATEADD(MM, 142, @StartDay ),
DATEADD(MM, 143, @StartDay ),
DATEADD(MM, 144, @StartDay ),
DATEADD(MM, 145, @StartDay ),
DATEADD(MM, 146, @StartDay ),
DATEADD(MM, 147, @StartDay ),
DATEADD(MM, 148, @StartDay ),
DATEADD(MM, 149, @StartDay ),
DATEADD(MM, 150, @StartDay ),
DATEADD(MM, 151, @StartDay ),
DATEADD(MM, 152, @StartDay ),
DATEADD(MM, 153, @StartDay ),
DATEADD(MM, 154, @StartDay ),
DATEADD(MM, 155, @StartDay ),
DATEADD(MM, 156, @StartDay ),
DATEADD(MM, 157, @StartDay ),
DATEADD(MM, 158, @StartDay ),
DATEADD(MM, 159, @StartDay ),
DATEADD(MM, 160, @StartDay ),
DATEADD(MM, 161, @StartDay ),
DATEADD(MM, 162, @StartDay ),
DATEADD(MM, 163, @StartDay ),
DATEADD(MM, 164, @StartDay ),
DATEADD(MM, 165, @StartDay ),
DATEADD(MM, 166, @StartDay ),
DATEADD(MM, 167, @StartDay ),
DATEADD(MM, 168, @StartDay ),
DATEADD(MM, 169, @StartDay ),
DATEADD(MM, 170, @StartDay ),
DATEADD(MM, 171, @StartDay ),
DATEADD(MM, 172, @StartDay ),
DATEADD(MM, 173, @StartDay ),
DATEADD(MM, 174, @StartDay ),
DATEADD(MM, 175, @StartDay ),
DATEADD(MM, 176, @StartDay ),
DATEADD(MM, 177, @StartDay ),
DATEADD(MM, 178, @StartDay ),
DATEADD(MM, 179, @StartDay ),
DATEADD(MM, 180, @StartDay ),
DATEADD(MM, 181, @StartDay ),
DATEADD(MM, 182, @StartDay ),
DATEADD(MM, 183, @StartDay ),
DATEADD(MM, 184, @StartDay ),
DATEADD(MM, 185, @StartDay ),
DATEADD(MM, 186, @StartDay ),
DATEADD(MM, 187, @StartDay ),
DATEADD(MM, 188, @StartDay ),
DATEADD(MM, 189, @StartDay ),
DATEADD(MM, 190, @StartDay ),
DATEADD(MM, 191, @StartDay ),
DATEADD(MM, 192, @StartDay ),
DATEADD(MM, 193, @StartDay ),
DATEADD(MM, 194, @StartDay ),
DATEADD(MM, 195, @StartDay ),
DATEADD(MM, 196, @StartDay ),
DATEADD(MM, 197, @StartDay ),
DATEADD(MM, 198, @StartDay ),
DATEADD(MM, 199, @StartDay ),
DATEADD(MM, 200, @StartDay ),
DATEADD(MM, 201, @StartDay ),
DATEADD(MM, 202, @StartDay ),
DATEADD(MM, 203, @StartDay ),
DATEADD(MM, 204, @StartDay ),
DATEADD(MM, 205, @StartDay ),
DATEADD(MM, 206, @StartDay ),
DATEADD(MM, 207, @StartDay ),
DATEADD(MM, 208, @StartDay ),
DATEADD(MM, 209, @StartDay ),
DATEADD(MM, 210, @StartDay ),
DATEADD(MM, 211, @StartDay ),
DATEADD(MM, 212, @StartDay ),
DATEADD(MM, 213, @StartDay ),
DATEADD(MM, 214, @StartDay ),
DATEADD(MM, 215, @StartDay ),
DATEADD(MM, 216, @StartDay ),
DATEADD(MM, 217, @StartDay ),
DATEADD(MM, 218, @StartDay ),
DATEADD(MM, 219, @StartDay ),
DATEADD(MM, 220, @StartDay ),
DATEADD(MM, 221, @StartDay ),
DATEADD(MM, 222, @StartDay ),
DATEADD(MM, 223, @StartDay ),
DATEADD(MM, 224, @StartDay ),
DATEADD(MM, 225, @StartDay ),
DATEADD(MM, 226, @StartDay ),
DATEADD(MM, 227, @StartDay ),
DATEADD(MM, 228, @StartDay ),
DATEADD(MM, 229, @StartDay ),
DATEADD(MM, 230, @StartDay ),
DATEADD(MM, 231, @StartDay ),
DATEADD(MM, 232, @StartDay ),
DATEADD(MM, 233, @StartDay ),
DATEADD(MM, 234, @StartDay ),
DATEADD(MM, 235, @StartDay ),
DATEADD(MM, 236, @StartDay ),
DATEADD(MM, 237, @StartDay ),
DATEADD(MM, 238, @StartDay ),
DATEADD(MM, 239, @StartDay ),
DATEADD(MM, 240, @StartDay ),
DATEADD(MM, 241, @StartDay ),
DATEADD(MM, 242, @StartDay ),
DATEADD(MM, 243, @StartDay ),
DATEADD(MM, 244, @StartDay ),
DATEADD(MM, 245, @StartDay ),
DATEADD(MM, 246, @StartDay ),
DATEADD(MM, 247, @StartDay ),
DATEADD(MM, 248, @StartDay ),
DATEADD(MM, 249, @StartDay ),
DATEADD(MM, 250, @StartDay ),
DATEADD(MM, 251, @StartDay ),
DATEADD(MM, 252, @StartDay ),
DATEADD(MM, 253, @StartDay ),
DATEADD(MM, 254, @StartDay ),
DATEADD(MM, 255, @StartDay ),
DATEADD(MM, 256, @StartDay ),
DATEADD(MM, 257, @StartDay ),
DATEADD(MM, 258, @StartDay ),
DATEADD(MM, 259, @StartDay ),
DATEADD(MM, 260, @StartDay ),
DATEADD(MM, 261, @StartDay ),
DATEADD(MM, 262, @StartDay ),
DATEADD(MM, 263, @StartDay ),
DATEADD(MM, 264, @StartDay ),
DATEADD(MM, 265, @StartDay ),
DATEADD(MM, 266, @StartDay ),
DATEADD(MM, 267, @StartDay ),
DATEADD(MM, 268, @StartDay ),
DATEADD(MM, 269, @StartDay ),
DATEADD(MM, 270, @StartDay ),
DATEADD(MM, 271, @StartDay ),
DATEADD(MM, 272, @StartDay ),
DATEADD(MM, 273, @StartDay ),
DATEADD(MM, 274, @StartDay ),
DATEADD(MM, 275, @StartDay ),
DATEADD(MM, 276, @StartDay ),
DATEADD(MM, 277, @StartDay ),
DATEADD(MM, 278, @StartDay ),
DATEADD(MM, 279, @StartDay ),
DATEADD(MM, 280, @StartDay ),
DATEADD(MM, 281, @StartDay ),
DATEADD(MM, 282, @StartDay ),
DATEADD(MM, 283, @StartDay ),
DATEADD(MM, 284, @StartDay ),
DATEADD(MM, 285, @StartDay ),
DATEADD(MM, 286, @StartDay ),
DATEADD(MM, 287, @StartDay ),
DATEADD(MM, 288, @StartDay ),
DATEADD(MM, 289, @StartDay ),
DATEADD(MM, 290, @StartDay ),
DATEADD(MM, 291, @StartDay ),
DATEADD(MM, 292, @StartDay ),
DATEADD(MM, 293, @StartDay ),
DATEADD(MM, 294, @StartDay ),
DATEADD(MM, 295, @StartDay ),
DATEADD(MM, 296, @StartDay ),
DATEADD(MM, 297, @StartDay ),
DATEADD(MM, 298, @StartDay ),
DATEADD(MM, 299, @StartDay ),
DATEADD(MM, 300, @StartDay ),
DATEADD(MM, 301, @StartDay ),
DATEADD(MM, 302, @StartDay ),
DATEADD(MM, 303, @StartDay ),
DATEADD(MM, 304, @StartDay ),
DATEADD(MM, 305, @StartDay ),
DATEADD(MM, 306, @StartDay ),
DATEADD(MM, 307, @StartDay ),
DATEADD(MM, 308, @StartDay ),
DATEADD(MM, 309, @StartDay ),
DATEADD(MM, 310, @StartDay ),
DATEADD(MM, 311, @StartDay ),
DATEADD(MM, 312, @StartDay ),
DATEADD(MM, 313, @StartDay ),
DATEADD(MM, 314, @StartDay ),
DATEADD(MM, 315, @StartDay ),
DATEADD(MM, 316, @StartDay ),
DATEADD(MM, 317, @StartDay ),
DATEADD(MM, 318, @StartDay ),
DATEADD(MM, 319, @StartDay ),
DATEADD(MM, 320, @StartDay ),
DATEADD(MM, 321, @StartDay ),
DATEADD(MM, 322, @StartDay ),
DATEADD(MM, 323, @StartDay ),
DATEADD(MM, 324, @StartDay ),
DATEADD(MM, 325, @StartDay ),
DATEADD(MM, 326, @StartDay ),
DATEADD(MM, 327, @StartDay ),
DATEADD(MM, 328, @StartDay ),
DATEADD(MM, 329, @StartDay ),
DATEADD(MM, 330, @StartDay ),
DATEADD(MM, 331, @StartDay ),
DATEADD(MM, 332, @StartDay ),
DATEADD(MM, 333, @StartDay ),
DATEADD(MM, 334, @StartDay ),
DATEADD(MM, 335, @StartDay ),
DATEADD(MM, 336, @StartDay ),
DATEADD(MM, 337, @StartDay ),
DATEADD(MM, 338, @StartDay ),
DATEADD(MM, 339, @StartDay ),
DATEADD(MM, 340, @StartDay ),
DATEADD(MM, 341, @StartDay ),
DATEADD(MM, 342, @StartDay ),
DATEADD(MM, 343, @StartDay ),
DATEADD(MM, 344, @StartDay ),
DATEADD(MM, 345, @StartDay ),
DATEADD(MM, 346, @StartDay ),
DATEADD(MM, 347, @StartDay ),
DATEADD(MM, 348, @StartDay ),
DATEADD(MM, 349, @StartDay ),
DATEADD(MM, 350, @StartDay ),
DATEADD(MM, 351, @StartDay ),
DATEADD(MM, 352, @StartDay ),
DATEADD(MM, 353, @StartDay ),
DATEADD(MM, 354, @StartDay ),
DATEADD(MM, 355, @StartDay ),
DATEADD(MM, 356, @StartDay ),
DATEADD(MM, 357, @StartDay ),
DATEADD(MM, 358, @StartDay ),
DATEADD(MM, 359, @StartDay ),
DATEADD(MM, 360, @StartDay ),
DATEADD(MM, 361, @StartDay ),
DATEADD(MM, 362, @StartDay ),
DATEADD(MM, 363, @StartDay ),
DATEADD(MM, 364, @StartDay ),
DATEADD(MM, 365, @StartDay ),
DATEADD(MM, 366, @StartDay ),
DATEADD(MM, 367, @StartDay ),
DATEADD(MM, 368, @StartDay ),
DATEADD(MM, 369, @StartDay ),
DATEADD(MM, 370, @StartDay ),
DATEADD(MM, 371, @StartDay ),
DATEADD(MM, 372, @StartDay ),
DATEADD(MM, 373, @StartDay ),
DATEADD(MM, 374, @StartDay ),
DATEADD(MM, 375, @StartDay ),
DATEADD(MM, 376, @StartDay ),
DATEADD(MM, 377, @StartDay ),
DATEADD(MM, 378, @StartDay ),
DATEADD(MM, 379, @StartDay ),
DATEADD(MM, 380, @StartDay ),
DATEADD(MM, 381, @StartDay ),
DATEADD(MM, 382, @StartDay ),
DATEADD(MM, 383, @StartDay ),
DATEADD(MM, 384, @StartDay ),
DATEADD(MM, 385, @StartDay ),
DATEADD(MM, 386, @StartDay ),
DATEADD(MM, 387, @StartDay ),
DATEADD(MM, 388, @StartDay ),
DATEADD(MM, 389, @StartDay ),
DATEADD(MM, 390, @StartDay ),
DATEADD(MM, 391, @StartDay ),
DATEADD(MM, 392, @StartDay ),
DATEADD(MM, 393, @StartDay ),
DATEADD(MM, 394, @StartDay ),
DATEADD(MM, 395, @StartDay ),
DATEADD(MM, 396, @StartDay ),
DATEADD(MM, 397, @StartDay ),
DATEADD(MM, 398, @StartDay ),
DATEADD(MM, 399, @StartDay ),
DATEADD(MM, 400, @StartDay ),
DATEADD(MM, 401, @StartDay ),
DATEADD(MM, 402, @StartDay ),
DATEADD(MM, 403, @StartDay ),
DATEADD(MM, 404, @StartDay ),
DATEADD(MM, 405, @StartDay ),
DATEADD(MM, 406, @StartDay ),
DATEADD(MM, 407, @StartDay ),
DATEADD(MM, 408, @StartDay ),
DATEADD(MM, 409, @StartDay ),
DATEADD(MM, 410, @StartDay ),
DATEADD(MM, 411, @StartDay ),
DATEADD(MM, 412, @StartDay ),
DATEADD(MM, 413, @StartDay ),
DATEADD(MM, 414, @StartDay ),
DATEADD(MM, 415, @StartDay ),
DATEADD(MM, 416, @StartDay ),
DATEADD(MM, 417, @StartDay ),
DATEADD(MM, 418, @StartDay ),
DATEADD(MM, 419, @StartDay ),
DATEADD(MM, 420, @StartDay ),
DATEADD(MM, 421, @StartDay ),
DATEADD(MM, 422, @StartDay ),
DATEADD(MM, 423, @StartDay ),
DATEADD(MM, 424, @StartDay ),
DATEADD(MM, 425, @StartDay ),
DATEADD(MM, 426, @StartDay ),
DATEADD(MM, 427, @StartDay ),
DATEADD(MM, 428, @StartDay ),
DATEADD(MM, 429, @StartDay ),
DATEADD(MM, 430, @StartDay ),
DATEADD(MM, 431, @StartDay ),
DATEADD(MM, 432, @StartDay ),
DATEADD(MM, 433, @StartDay ),
DATEADD(MM, 434, @StartDay ),
DATEADD(MM, 435, @StartDay ),
DATEADD(MM, 436, @StartDay ),
DATEADD(MM, 437, @StartDay ),
DATEADD(MM, 438, @StartDay ),
DATEADD(MM, 439, @StartDay ),
DATEADD(MM, 440, @StartDay ),
DATEADD(MM, 441, @StartDay ),
DATEADD(MM, 442, @StartDay ),
DATEADD(MM, 443, @StartDay ),
DATEADD(MM, 444, @StartDay ),
DATEADD(MM, 445, @StartDay ),
DATEADD(MM, 446, @StartDay ),
DATEADD(MM, 447, @StartDay ),
DATEADD(MM, 448, @StartDay ),
DATEADD(MM, 449, @StartDay ),
DATEADD(MM, 450, @StartDay ),
DATEADD(MM, 451, @StartDay ),
DATEADD(MM, 452, @StartDay ),
DATEADD(MM, 453, @StartDay ),
DATEADD(MM, 454, @StartDay ),
DATEADD(MM, 455, @StartDay ),
DATEADD(MM, 456, @StartDay ),
DATEADD(MM, 457, @StartDay ),
DATEADD(MM, 458, @StartDay ),
DATEADD(MM, 459, @StartDay ),
DATEADD(MM, 460, @StartDay ),
DATEADD(MM, 461, @StartDay ),
DATEADD(MM, 462, @StartDay ),
DATEADD(MM, 463, @StartDay ),
DATEADD(MM, 464, @StartDay ),
DATEADD(MM, 465, @StartDay ),
DATEADD(MM, 466, @StartDay ),
DATEADD(MM, 467, @StartDay ),
DATEADD(MM, 468, @StartDay ),
DATEADD(MM, 469, @StartDay ),
DATEADD(MM, 470, @StartDay ),
DATEADD(MM, 471, @StartDay ),
DATEADD(MM, 472, @StartDay ),
DATEADD(MM, 473, @StartDay ),
DATEADD(MM, 474, @StartDay ),
DATEADD(MM, 475, @StartDay ),
DATEADD(MM, 476, @StartDay ),
DATEADD(MM, 477, @StartDay ),
DATEADD(MM, 478, @StartDay ),
DATEADD(MM, 479, @StartDay ),
DATEADD(MM, 480, @StartDay ),
DATEADD(MM, 481, @StartDay ),
DATEADD(MM, 482, @StartDay ),
DATEADD(MM, 483, @StartDay ),
DATEADD(MM, 484, @StartDay ),
DATEADD(MM, 485, @StartDay ),
DATEADD(MM, 486, @StartDay ),
DATEADD(MM, 487, @StartDay ),
DATEADD(MM, 488, @StartDay ),
DATEADD(MM, 489, @StartDay ),
DATEADD(MM, 490, @StartDay ),
DATEADD(MM, 491, @StartDay ),
DATEADD(MM, 492, @StartDay ),
DATEADD(MM, 493, @StartDay ),
DATEADD(MM, 494, @StartDay ),
DATEADD(MM, 495, @StartDay ),
DATEADD(MM, 496, @StartDay ),
DATEADD(MM, 497, @StartDay ),
DATEADD(MM, 498, @StartDay ),
DATEADD(MM, 499, @StartDay ),
DATEADD(MM, 500, @StartDay ),
DATEADD(MM, 501, @StartDay ),
DATEADD(MM, 502, @StartDay ),
DATEADD(MM, 503, @StartDay ),
DATEADD(MM, 504, @StartDay ),
DATEADD(MM, 505, @StartDay ),
DATEADD(MM, 506, @StartDay ),
DATEADD(MM, 507, @StartDay ),
DATEADD(MM, 508, @StartDay ),
DATEADD(MM, 509, @StartDay ),
DATEADD(MM, 510, @StartDay ),
DATEADD(MM, 511, @StartDay ),
DATEADD(MM, 512, @StartDay ),
DATEADD(MM, 513, @StartDay ),
DATEADD(MM, 514, @StartDay ),
DATEADD(MM, 515, @StartDay ),
DATEADD(MM, 516, @StartDay ),
DATEADD(MM, 517, @StartDay ),
DATEADD(MM, 518, @StartDay ),
DATEADD(MM, 519, @StartDay ),
DATEADD(MM, 520, @StartDay ),
DATEADD(MM, 521, @StartDay ),
DATEADD(MM, 522, @StartDay ),
DATEADD(MM, 523, @StartDay ),
DATEADD(MM, 524, @StartDay ),
DATEADD(MM, 525, @StartDay ),
DATEADD(MM, 526, @StartDay ),
DATEADD(MM, 527, @StartDay ),
DATEADD(MM, 528, @StartDay ),
DATEADD(MM, 529, @StartDay ),
DATEADD(MM, 530, @StartDay ),
DATEADD(MM, 531, @StartDay ),
DATEADD(MM, 532, @StartDay ),
DATEADD(MM, 533, @StartDay ),
DATEADD(MM, 534, @StartDay ),
DATEADD(MM, 535, @StartDay ),
DATEADD(MM, 536, @StartDay ),
DATEADD(MM, 537, @StartDay ),
DATEADD(MM, 538, @StartDay ),
DATEADD(MM, 539, @StartDay ),
DATEADD(MM, 540, @StartDay ),
DATEADD(MM, 541, @StartDay ),
DATEADD(MM, 542, @StartDay ),
DATEADD(MM, 543, @StartDay ),
DATEADD(MM, 544, @StartDay ),
DATEADD(MM, 545, @StartDay ),
DATEADD(MM, 546, @StartDay ),
DATEADD(MM, 547, @StartDay ),
DATEADD(MM, 548, @StartDay ),
DATEADD(MM, 549, @StartDay ),
DATEADD(MM, 550, @StartDay ),
DATEADD(MM, 551, @StartDay ),
DATEADD(MM, 552, @StartDay ),
DATEADD(MM, 553, @StartDay ),
DATEADD(MM, 554, @StartDay ),
DATEADD(MM, 555, @StartDay ),
DATEADD(MM, 556, @StartDay ),
DATEADD(MM, 557, @StartDay ),
DATEADD(MM, 558, @StartDay ),
DATEADD(MM, 559, @StartDay ),
DATEADD(MM, 560, @StartDay ),
DATEADD(MM, 561, @StartDay ),
DATEADD(MM, 562, @StartDay ),
DATEADD(MM, 563, @StartDay ),
DATEADD(MM, 564, @StartDay ),
DATEADD(MM, 565, @StartDay ),
DATEADD(MM, 566, @StartDay ),
DATEADD(MM, 567, @StartDay ),
DATEADD(MM, 568, @StartDay ),
DATEADD(MM, 569, @StartDay ),
DATEADD(MM, 570, @StartDay ),
DATEADD(MM, 571, @StartDay ),
DATEADD(MM, 572, @StartDay ),
DATEADD(MM, 573, @StartDay ),
DATEADD(MM, 574, @StartDay ),
DATEADD(MM, 575, @StartDay ),
DATEADD(MM, 576, @StartDay ),
DATEADD(MM, 577, @StartDay ),
DATEADD(MM, 578, @StartDay ),
DATEADD(MM, 579, @StartDay ),
DATEADD(MM, 580, @StartDay ),
DATEADD(MM, 581, @StartDay ),
DATEADD(MM, 582, @StartDay ),
DATEADD(MM, 583, @StartDay ),
DATEADD(MM, 584, @StartDay ),
DATEADD(MM, 585, @StartDay ),
DATEADD(MM, 586, @StartDay ),
DATEADD(MM, 587, @StartDay ),
DATEADD(MM, 588, @StartDay ),
DATEADD(MM, 589, @StartDay ),
DATEADD(MM, 590, @StartDay ),
DATEADD(MM, 591, @StartDay ),
DATEADD(MM, 592, @StartDay ),
DATEADD(MM, 593, @StartDay ),
DATEADD(MM, 594, @StartDay ),
DATEADD(MM, 595, @StartDay ),
DATEADD(MM, 596, @StartDay ),
DATEADD(MM, 597, @StartDay ),
DATEADD(MM, 598, @StartDay ),
DATEADD(MM, 599, @StartDay ),
DATEADD(MM, 600, @StartDay ),
DATEADD(MM, 601, @StartDay ),
DATEADD(MM, 602, @StartDay ),
DATEADD(MM, 603, @StartDay ),
DATEADD(MM, 604, @StartDay ),
DATEADD(MM, 605, @StartDay ),
DATEADD(MM, 606, @StartDay ),
DATEADD(MM, 607, @StartDay ),
DATEADD(MM, 608, @StartDay ),
DATEADD(MM, 609, @StartDay ),
DATEADD(MM, 610, @StartDay ),
DATEADD(MM, 611, @StartDay ),
DATEADD(MM, 612, @StartDay ),
DATEADD(MM, 613, @StartDay ),
DATEADD(MM, 614, @StartDay ),
DATEADD(MM, 615, @StartDay ),
DATEADD(MM, 616, @StartDay ),
DATEADD(MM, 617, @StartDay ),
DATEADD(MM, 618, @StartDay ),
DATEADD(MM, 619, @StartDay ),
DATEADD(MM, 620, @StartDay ),
DATEADD(MM, 621, @StartDay ),
DATEADD(MM, 622, @StartDay ),
DATEADD(MM, 623, @StartDay ),
DATEADD(MM, 624, @StartDay ),
DATEADD(MM, 625, @StartDay ),
DATEADD(MM, 626, @StartDay ),
DATEADD(MM, 627, @StartDay ),
DATEADD(MM, 628, @StartDay ),
DATEADD(MM, 629, @StartDay ),
DATEADD(MM, 630, @StartDay ),
DATEADD(MM, 631, @StartDay ),
DATEADD(MM, 632, @StartDay ),
DATEADD(MM, 633, @StartDay ),
DATEADD(MM, 634, @StartDay ),
DATEADD(MM, 635, @StartDay ),
DATEADD(MM, 636, @StartDay ),
DATEADD(MM, 637, @StartDay ),
DATEADD(MM, 638, @StartDay ),
DATEADD(MM, 639, @StartDay ),
DATEADD(MM, 640, @StartDay ),
DATEADD(MM, 641, @StartDay ),
DATEADD(MM, 642, @StartDay ),
DATEADD(MM, 643, @StartDay ),
DATEADD(MM, 644, @StartDay ),
DATEADD(MM, 645, @StartDay ),
DATEADD(MM, 646, @StartDay ),
DATEADD(MM, 647, @StartDay ),
DATEADD(MM, 648, @StartDay ),
DATEADD(MM, 649, @StartDay ),
DATEADD(MM, 650, @StartDay ),
DATEADD(MM, 651, @StartDay ),
DATEADD(MM, 652, @StartDay ),
DATEADD(MM, 653, @StartDay ),
DATEADD(MM, 654, @StartDay ),
DATEADD(MM, 655, @StartDay ),
DATEADD(MM, 656, @StartDay ),
DATEADD(MM, 657, @StartDay ),
DATEADD(MM, 658, @StartDay ),
DATEADD(MM, 659, @StartDay ),
DATEADD(MM, 660, @StartDay ),
DATEADD(MM, 661, @StartDay ),
DATEADD(MM, 662, @StartDay ),
DATEADD(MM, 663, @StartDay ),
DATEADD(MM, 664, @StartDay ),
DATEADD(MM, 665, @StartDay ),
DATEADD(MM, 666, @StartDay ),
DATEADD(MM, 667, @StartDay ),
DATEADD(MM, 668, @StartDay ),
DATEADD(MM, 669, @StartDay ),
DATEADD(MM, 670, @StartDay ),
DATEADD(MM, 671, @StartDay ),
DATEADD(MM, 672, @StartDay ),
DATEADD(MM, 673, @StartDay ),
DATEADD(MM, 674, @StartDay ),
DATEADD(MM, 675, @StartDay ),
DATEADD(MM, 676, @StartDay ),
DATEADD(MM, 677, @StartDay ),
DATEADD(MM, 678, @StartDay ),
DATEADD(MM, 679, @StartDay ),
DATEADD(MM, 680, @StartDay ),
DATEADD(MM, 681, @StartDay ),
DATEADD(MM, 682, @StartDay ),
DATEADD(MM, 683, @StartDay ),
DATEADD(MM, 684, @StartDay ),
DATEADD(MM, 685, @StartDay ),
DATEADD(MM, 686, @StartDay ),
DATEADD(MM, 687, @StartDay ),
DATEADD(MM, 688, @StartDay ),
DATEADD(MM, 689, @StartDay ),
DATEADD(MM, 690, @StartDay ),
DATEADD(MM, 691, @StartDay ),
DATEADD(MM, 692, @StartDay ),
DATEADD(MM, 693, @StartDay ),
DATEADD(MM, 694, @StartDay ),
DATEADD(MM, 695, @StartDay ),
DATEADD(MM, 696, @StartDay ),
DATEADD(MM, 697, @StartDay ),
DATEADD(MM, 698, @StartDay ),
DATEADD(MM, 699, @StartDay ),
DATEADD(MM, 700, @StartDay ),
DATEADD(MM, 701, @StartDay ),
DATEADD(MM, 702, @StartDay ),
DATEADD(MM, 703, @StartDay ),
DATEADD(MM, 704, @StartDay ),
DATEADD(MM, 705, @StartDay ),
DATEADD(MM, 706, @StartDay ),
DATEADD(MM, 707, @StartDay ),
DATEADD(MM, 708, @StartDay ),
DATEADD(MM, 709, @StartDay ),
DATEADD(MM, 710, @StartDay ),
DATEADD(MM, 711, @StartDay ),
DATEADD(MM, 712, @StartDay ),
DATEADD(MM, 713, @StartDay ),
DATEADD(MM, 714, @StartDay ),
DATEADD(MM, 715, @StartDay ),
DATEADD(MM, 716, @StartDay ),
DATEADD(MM, 717, @StartDay ),
DATEADD(MM, 718, @StartDay ),
DATEADD(MM, 719, @StartDay ),
DATEADD(MM, 720, @StartDay ),
DATEADD(MM, 721, @StartDay ),
DATEADD(MM, 722, @StartDay ),
DATEADD(MM, 723, @StartDay ),
DATEADD(MM, 724, @StartDay ),
DATEADD(MM, 725, @StartDay ),
DATEADD(MM, 726, @StartDay ),
DATEADD(MM, 727, @StartDay ),
DATEADD(MM, 728, @StartDay ),
DATEADD(MM, 729, @StartDay ),
DATEADD(MM, 730, @StartDay ),
DATEADD(MM, 731, @StartDay ),
DATEADD(MM, 732, @StartDay ),
DATEADD(MM, 733, @StartDay ),
DATEADD(MM, 734, @StartDay ),
DATEADD(MM, 735, @StartDay ),
DATEADD(MM, 736, @StartDay ),
DATEADD(MM, 737, @StartDay ),
DATEADD(MM, 738, @StartDay ),
DATEADD(MM, 739, @StartDay ),
DATEADD(MM, 740, @StartDay ),
DATEADD(MM, 741, @StartDay ),
DATEADD(MM, 742, @StartDay ),
DATEADD(MM, 743, @StartDay ),
DATEADD(MM, 744, @StartDay ),
DATEADD(MM, 745, @StartDay ),
DATEADD(MM, 746, @StartDay ),
DATEADD(MM, 747, @StartDay ),
DATEADD(MM, 748, @StartDay ),
DATEADD(MM, 749, @StartDay ),
DATEADD(MM, 750, @StartDay ),
DATEADD(MM, 751, @StartDay ),
DATEADD(MM, 752, @StartDay ),
DATEADD(MM, 753, @StartDay ),
DATEADD(MM, 754, @StartDay ),
DATEADD(MM, 755, @StartDay ),
DATEADD(MM, 756, @StartDay ),
DATEADD(MM, 757, @StartDay ),
DATEADD(MM, 758, @StartDay ),
DATEADD(MM, 759, @StartDay ),
DATEADD(MM, 760, @StartDay ),
DATEADD(MM, 761, @StartDay ),
DATEADD(MM, 762, @StartDay ),
DATEADD(MM, 763, @StartDay ),
DATEADD(MM, 764, @StartDay ),
DATEADD(MM, 765, @StartDay ),
DATEADD(MM, 766, @StartDay ),
DATEADD(MM, 767, @StartDay ),
DATEADD(MM, 768, @StartDay ),
DATEADD(MM, 769, @StartDay ),
DATEADD(MM, 770, @StartDay ),
DATEADD(MM, 771, @StartDay ),
DATEADD(MM, 772, @StartDay ),
DATEADD(MM, 773, @StartDay ),
DATEADD(MM, 774, @StartDay ),
DATEADD(MM, 775, @StartDay ),
DATEADD(MM, 776, @StartDay ),
DATEADD(MM, 777, @StartDay ),
DATEADD(MM, 778, @StartDay ),
DATEADD(MM, 779, @StartDay ),
DATEADD(MM, 780, @StartDay ),
DATEADD(MM, 781, @StartDay ),
DATEADD(MM, 782, @StartDay ),
DATEADD(MM, 783, @StartDay ),
DATEADD(MM, 784, @StartDay ),
DATEADD(MM, 785, @StartDay ),
DATEADD(MM, 786, @StartDay ),
DATEADD(MM, 787, @StartDay ),
DATEADD(MM, 788, @StartDay ),
DATEADD(MM, 789, @StartDay ),
DATEADD(MM, 790, @StartDay ),
DATEADD(MM, 791, @StartDay ),
DATEADD(MM, 792, @StartDay ),
DATEADD(MM, 793, @StartDay ),
DATEADD(MM, 794, @StartDay ),
DATEADD(MM, 795, @StartDay ),
DATEADD(MM, 796, @StartDay ),
DATEADD(MM, 797, @StartDay ),
DATEADD(MM, 798, @StartDay ),
DATEADD(MM, 799, @StartDay ),
DATEADD(MM, 800, @StartDay ),
DATEADD(MM, 801, @StartDay ),
DATEADD(MM, 802, @StartDay ),
DATEADD(MM, 803, @StartDay ),
DATEADD(MM, 804, @StartDay ),
DATEADD(MM, 805, @StartDay ),
DATEADD(MM, 806, @StartDay ),
DATEADD(MM, 807, @StartDay ),
DATEADD(MM, 808, @StartDay ),
DATEADD(MM, 809, @StartDay ),
DATEADD(MM, 810, @StartDay ),
DATEADD(MM, 811, @StartDay ),
DATEADD(MM, 812, @StartDay ),
DATEADD(MM, 813, @StartDay ),
DATEADD(MM, 814, @StartDay ),
DATEADD(MM, 815, @StartDay ),
DATEADD(MM, 816, @StartDay ),
DATEADD(MM, 817, @StartDay ),
DATEADD(MM, 818, @StartDay ),
DATEADD(MM, 819, @StartDay ),
DATEADD(MM, 820, @StartDay ),
DATEADD(MM, 821, @StartDay ),
DATEADD(MM, 822, @StartDay ),
DATEADD(MM, 823, @StartDay ),
DATEADD(MM, 824, @StartDay ),
DATEADD(MM, 825, @StartDay ),
DATEADD(MM, 826, @StartDay ),
DATEADD(MM, 827, @StartDay ),
DATEADD(MM, 828, @StartDay ),
DATEADD(MM, 829, @StartDay ),
DATEADD(MM, 830, @StartDay ),
DATEADD(MM, 831, @StartDay ),
DATEADD(MM, 832, @StartDay ),
DATEADD(MM, 833, @StartDay ),
DATEADD(MM, 834, @StartDay ),
DATEADD(MM, 835, @StartDay ),
DATEADD(MM, 836, @StartDay ),
DATEADD(MM, 837, @StartDay ),
DATEADD(MM, 838, @StartDay ),
DATEADD(MM, 839, @StartDay ),
DATEADD(MM, 840, @StartDay ),
DATEADD(MM, 841, @StartDay ),
DATEADD(MM, 842, @StartDay ),
DATEADD(MM, 843, @StartDay ),
DATEADD(MM, 844, @StartDay ),
DATEADD(MM, 845, @StartDay ),
DATEADD(MM, 846, @StartDay ),
DATEADD(MM, 847, @StartDay ),
DATEADD(MM, 848, @StartDay ),
DATEADD(MM, 849, @StartDay ),
DATEADD(MM, 850, @StartDay ),
DATEADD(MM, 851, @StartDay ),
DATEADD(MM, 852, @StartDay ),
DATEADD(MM, 853, @StartDay ),
DATEADD(MM, 854, @StartDay ),
DATEADD(MM, 855, @StartDay ),
DATEADD(MM, 856, @StartDay ),
DATEADD(MM, 857, @StartDay ),
DATEADD(MM, 858, @StartDay ),
DATEADD(MM, 859, @StartDay ),
DATEADD(MM, 860, @StartDay ),
DATEADD(MM, 861, @StartDay ),
DATEADD(MM, 862, @StartDay ),
DATEADD(MM, 863, @StartDay ),
DATEADD(MM, 864, @StartDay ),
DATEADD(MM, 865, @StartDay ),
DATEADD(MM, 866, @StartDay ),
DATEADD(MM, 867, @StartDay ),
DATEADD(MM, 868, @StartDay ),
DATEADD(MM, 869, @StartDay ),
DATEADD(MM, 870, @StartDay ),
DATEADD(MM, 871, @StartDay ),
DATEADD(MM, 872, @StartDay ),
DATEADD(MM, 873, @StartDay ),
DATEADD(MM, 874, @StartDay ),
DATEADD(MM, 875, @StartDay ),
DATEADD(MM, 876, @StartDay ),
DATEADD(MM, 877, @StartDay ),
DATEADD(MM, 878, @StartDay ),
DATEADD(MM, 879, @StartDay ),
DATEADD(MM, 880, @StartDay ),
DATEADD(MM, 881, @StartDay ),
DATEADD(MM, 882, @StartDay ),
DATEADD(MM, 883, @StartDay ),
DATEADD(MM, 884, @StartDay ),
DATEADD(MM, 885, @StartDay ),
DATEADD(MM, 886, @StartDay ),
DATEADD(MM, 887, @StartDay ),
DATEADD(MM, 888, @StartDay ),
DATEADD(MM, 889, @StartDay ),
DATEADD(MM, 890, @StartDay ),
DATEADD(MM, 891, @StartDay ),
DATEADD(MM, 892, @StartDay ),
DATEADD(MM, 893, @StartDay ),
DATEADD(MM, 894, @StartDay ),
DATEADD(MM, 895, @StartDay ),
DATEADD(MM, 896, @StartDay ),
DATEADD(MM, 897, @StartDay ),
DATEADD(MM, 898, @StartDay ),
DATEADD(MM, 899, @StartDay ),
DATEADD(MM, 900, @StartDay ),
DATEADD(MM, 901, @StartDay ),
DATEADD(MM, 902, @StartDay ),
DATEADD(MM, 903, @StartDay ),
DATEADD(MM, 904, @StartDay ),
DATEADD(MM, 905, @StartDay ),
DATEADD(MM, 906, @StartDay ),
DATEADD(MM, 907, @StartDay ),
DATEADD(MM, 908, @StartDay ),
DATEADD(MM, 909, @StartDay ),
DATEADD(MM, 910, @StartDay ),
DATEADD(MM, 911, @StartDay ),
DATEADD(MM, 912, @StartDay ),
DATEADD(MM, 913, @StartDay ),
DATEADD(MM, 914, @StartDay ),
DATEADD(MM, 915, @StartDay ),
DATEADD(MM, 916, @StartDay ),
DATEADD(MM, 917, @StartDay ),
DATEADD(MM, 918, @StartDay ),
DATEADD(MM, 919, @StartDay ),
DATEADD(MM, 920, @StartDay ),
DATEADD(MM, 921, @StartDay ),
DATEADD(MM, 922, @StartDay ),
DATEADD(MM, 923, @StartDay ),
DATEADD(MM, 924, @StartDay ),
DATEADD(MM, 925, @StartDay ),
DATEADD(MM, 926, @StartDay ),
DATEADD(MM, 927, @StartDay ),
DATEADD(MM, 928, @StartDay ),
DATEADD(MM, 929, @StartDay ),
DATEADD(MM, 930, @StartDay ),
DATEADD(MM, 931, @StartDay ),
DATEADD(MM, 932, @StartDay ),
DATEADD(MM, 933, @StartDay ),
DATEADD(MM, 934, @StartDay ),
DATEADD(MM, 935, @StartDay ),
DATEADD(MM, 936, @StartDay ),
DATEADD(MM, 937, @StartDay ),
DATEADD(MM, 938, @StartDay ),
DATEADD(MM, 939, @StartDay ),
DATEADD(MM, 940, @StartDay ),
DATEADD(MM, 941, @StartDay ),
DATEADD(MM, 942, @StartDay ),
DATEADD(MM, 943, @StartDay ),
DATEADD(MM, 944, @StartDay ),
DATEADD(MM, 945, @StartDay ),
DATEADD(MM, 946, @StartDay ),
DATEADD(MM, 947, @StartDay ),
DATEADD(MM, 948, @StartDay ),
DATEADD(MM, 949, @StartDay ),
DATEADD(MM, 950, @StartDay ),
DATEADD(MM, 951, @StartDay ),
DATEADD(MM, 952, @StartDay ),
DATEADD(MM, 953, @StartDay ),
DATEADD(MM, 954, @StartDay ),
DATEADD(MM, 955, @StartDay ),
DATEADD(MM, 956, @StartDay ),
DATEADD(MM, 957, @StartDay ),
DATEADD(MM, 958, @StartDay ),
DATEADD(MM, 959, @StartDay ),
DATEADD(MM, 960, @StartDay ),
DATEADD(MM, 961, @StartDay ),
DATEADD(MM, 962, @StartDay ),
DATEADD(MM, 963, @StartDay ),
DATEADD(MM, 964, @StartDay ),
DATEADD(MM, 965, @StartDay ),
DATEADD(MM, 966, @StartDay ),
DATEADD(MM, 967, @StartDay ),
DATEADD(MM, 968, @StartDay ),
DATEADD(MM, 969, @StartDay ),
DATEADD(MM, 970, @StartDay ),
DATEADD(MM, 971, @StartDay ),
DATEADD(MM, 972, @StartDay ),
DATEADD(MM, 973, @StartDay ),
DATEADD(MM, 974, @StartDay ),
DATEADD(MM, 975, @StartDay ),
DATEADD(MM, 976, @StartDay ),
DATEADD(MM, 977, @StartDay ),
DATEADD(MM, 978, @StartDay ),
DATEADD(MM, 979, @StartDay ),
DATEADD(MM, 980, @StartDay ),
DATEADD(MM, 981, @StartDay ),
DATEADD(MM, 982, @StartDay ),
DATEADD(MM, 983, @StartDay ),
DATEADD(MM, 984, @StartDay ),
DATEADD(MM, 985, @StartDay ),
DATEADD(MM, 986, @StartDay ),
DATEADD(MM, 987, @StartDay ),
DATEADD(MM, 988, @StartDay ),
DATEADD(MM, 989, @StartDay ),
DATEADD(MM, 990, @StartDay ),
DATEADD(MM, 991, @StartDay ),
DATEADD(MM, 992, @StartDay ),
DATEADD(MM, 993, @StartDay ),
DATEADD(MM, 994, @StartDay ),
DATEADD(MM, 995, @StartDay ),
DATEADD(MM, 996, @StartDay ),
DATEADD(MM, 997, @StartDay ),
DATEADD(MM, 998, @StartDay ));
GO
/* Build a partition function
;WITH
Pass0 as (select 1 as C union all select 1), --2 rows
Pass1 as (select 1 as C from Pass0 as A, Pass0 as B),--4 rows
Pass2 as (select 1 as C from Pass1 as A, Pass1 as B),--16 rows
Pass3 as (select 1 as C from Pass2 as A, Pass2 as B),--256 rows
Pass4 as (select 1 as C from Pass3 as A, Pass3 as B),--65536 rows
Tally as (select row_number() over(order by C) as Number from Pass4)
SELECT 'CREATE PARTITION SCHEME psMonthly AS PARTITION pfMonthly TO (' AS ScriptLine
UNION ALL
SELECT ' [PRIMARY], '
from Tally
where Number <= 999
UNION ALL
SELECT ' [PRIMARY] );';
GO
CREATE PARTITION SCHEME psMonthly
AS PARTITION pfMonthly
TO ([PRIMARY]);
GO
*/
CREATE PARTITION SCHEME psMonthly AS PARTITION pfMonthly TO (
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY],
[PRIMARY] );
GO
/* Build a list of 999 indexes, each on the partitioned scheme
SELECT TOP 999 'CREATE INDEX [IX_' + c1.COLUMN_NAME + '_' + c2.COLUMN_NAME + '_' + c3.COLUMN_NAME + ']'
+ ' ON [' + c1.TABLE_SCHEMA + '].[' + c1.TABLE_NAME + '] '
+ '([' + c1.COLUMN_NAME + '], [' + c2.COLUMN_NAME + '], [' + c3.COLUMN_NAME + ']) ON psMonthly(CreationDate);'
FROM INFORMATION_SCHEMA.COLUMNS c1
INNER JOIN INFORMATION_SCHEMA.COLUMNS c2 ON c1.TABLE_SCHEMA = c2.TABLE_SCHEMA AND c1.TABLE_NAME = c2.TABLE_NAME
AND c1.COLUMN_NAME <> c2.COLUMN_NAME
AND (c2.CHARACTER_MAXIMUM_LENGTH <> -1 OR c2.CHARACTER_MAXIMUM_LENGTH IS NULL)
INNER JOIN INFORMATION_SCHEMA.COLUMNS c3 ON c1.TABLE_SCHEMA = c3.TABLE_SCHEMA AND c1.TABLE_NAME = c3.TABLE_NAME
AND c3.COLUMN_NAME NOT IN (c1.COLUMN_NAME, c2.COLUMN_NAME)
AND (c3.CHARACTER_MAXIMUM_LENGTH <> -1 OR c3.CHARACTER_MAXIMUM_LENGTH IS NULL)
WHERE c1.TABLE_SCHEMA = 'dbo' AND c1.TABLE_NAME = 'Users'
AND (c1.CHARACTER_MAXIMUM_LENGTH <> -1 OR c1.CHARACTER_MAXIMUM_LENGTH IS NULL)
ORDER BY c3.COLUMN_NAME, c2.COLUMN_NAME;
GO
*/
CREATE INDEX [IX_Id_Age_AccountId] ON [dbo].[Users] ([Id], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Age_AccountId] ON [dbo].[Users] ([CreationDate], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Age_AccountId] ON [dbo].[Users] ([DisplayName], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Age_AccountId] ON [dbo].[Users] ([DownVotes], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Age_AccountId] ON [dbo].[Users] ([EmailHash], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Age_AccountId] ON [dbo].[Users] ([LastAccessDate], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Age_AccountId] ON [dbo].[Users] ([Location], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Age_AccountId] ON [dbo].[Users] ([Reputation], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Age_AccountId] ON [dbo].[Users] ([UpVotes], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Age_AccountId] ON [dbo].[Users] ([Views], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Age_AccountId] ON [dbo].[Users] ([WebsiteUrl], [Age], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_CreationDate_AccountId] ON [dbo].[Users] ([WebsiteUrl], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_CreationDate_AccountId] ON [dbo].[Users] ([Views], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_CreationDate_AccountId] ON [dbo].[Users] ([UpVotes], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_CreationDate_AccountId] ON [dbo].[Users] ([Reputation], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_CreationDate_AccountId] ON [dbo].[Users] ([Location], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_CreationDate_AccountId] ON [dbo].[Users] ([LastAccessDate], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_CreationDate_AccountId] ON [dbo].[Users] ([EmailHash], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_CreationDate_AccountId] ON [dbo].[Users] ([DownVotes], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_CreationDate_AccountId] ON [dbo].[Users] ([DisplayName], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_CreationDate_AccountId] ON [dbo].[Users] ([Id], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_CreationDate_AccountId] ON [dbo].[Users] ([Age], [CreationDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_DisplayName_AccountId] ON [dbo].[Users] ([Age], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_DisplayName_AccountId] ON [dbo].[Users] ([Id], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_DisplayName_AccountId] ON [dbo].[Users] ([CreationDate], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_DisplayName_AccountId] ON [dbo].[Users] ([DownVotes], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_DisplayName_AccountId] ON [dbo].[Users] ([EmailHash], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_DisplayName_AccountId] ON [dbo].[Users] ([LastAccessDate], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_DisplayName_AccountId] ON [dbo].[Users] ([Location], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_DisplayName_AccountId] ON [dbo].[Users] ([Reputation], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_DisplayName_AccountId] ON [dbo].[Users] ([UpVotes], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_DisplayName_AccountId] ON [dbo].[Users] ([Views], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_DisplayName_AccountId] ON [dbo].[Users] ([WebsiteUrl], [DisplayName], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_DownVotes_AccountId] ON [dbo].[Users] ([WebsiteUrl], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_DownVotes_AccountId] ON [dbo].[Users] ([Views], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_DownVotes_AccountId] ON [dbo].[Users] ([UpVotes], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_DownVotes_AccountId] ON [dbo].[Users] ([Reputation], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_DownVotes_AccountId] ON [dbo].[Users] ([Location], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_DownVotes_AccountId] ON [dbo].[Users] ([LastAccessDate], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_DownVotes_AccountId] ON [dbo].[Users] ([EmailHash], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_DownVotes_AccountId] ON [dbo].[Users] ([CreationDate], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_DownVotes_AccountId] ON [dbo].[Users] ([DisplayName], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_DownVotes_AccountId] ON [dbo].[Users] ([Id], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_DownVotes_AccountId] ON [dbo].[Users] ([Age], [DownVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_EmailHash_AccountId] ON [dbo].[Users] ([Age], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_EmailHash_AccountId] ON [dbo].[Users] ([Id], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_EmailHash_AccountId] ON [dbo].[Users] ([DisplayName], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_EmailHash_AccountId] ON [dbo].[Users] ([CreationDate], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_EmailHash_AccountId] ON [dbo].[Users] ([DownVotes], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_EmailHash_AccountId] ON [dbo].[Users] ([LastAccessDate], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_EmailHash_AccountId] ON [dbo].[Users] ([Location], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_EmailHash_AccountId] ON [dbo].[Users] ([Reputation], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_EmailHash_AccountId] ON [dbo].[Users] ([UpVotes], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_EmailHash_AccountId] ON [dbo].[Users] ([Views], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_EmailHash_AccountId] ON [dbo].[Users] ([WebsiteUrl], [EmailHash], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Id_AccountId] ON [dbo].[Users] ([Views], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Id_AccountId] ON [dbo].[Users] ([WebsiteUrl], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Id_AccountId] ON [dbo].[Users] ([UpVotes], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Id_AccountId] ON [dbo].[Users] ([Reputation], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Id_AccountId] ON [dbo].[Users] ([Location], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Id_AccountId] ON [dbo].[Users] ([LastAccessDate], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Id_AccountId] ON [dbo].[Users] ([DownVotes], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Id_AccountId] ON [dbo].[Users] ([EmailHash], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Id_AccountId] ON [dbo].[Users] ([CreationDate], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Id_AccountId] ON [dbo].[Users] ([DisplayName], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_Id_AccountId] ON [dbo].[Users] ([Age], [Id], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_LastAccessDate_AccountId] ON [dbo].[Users] ([Age], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_LastAccessDate_AccountId] ON [dbo].[Users] ([Id], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_LastAccessDate_AccountId] ON [dbo].[Users] ([DisplayName], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_LastAccessDate_AccountId] ON [dbo].[Users] ([CreationDate], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_LastAccessDate_AccountId] ON [dbo].[Users] ([EmailHash], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_LastAccessDate_AccountId] ON [dbo].[Users] ([DownVotes], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_LastAccessDate_AccountId] ON [dbo].[Users] ([Location], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_LastAccessDate_AccountId] ON [dbo].[Users] ([Reputation], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_LastAccessDate_AccountId] ON [dbo].[Users] ([UpVotes], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_LastAccessDate_AccountId] ON [dbo].[Users] ([Views], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_LastAccessDate_AccountId] ON [dbo].[Users] ([WebsiteUrl], [LastAccessDate], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Location_AccountId] ON [dbo].[Users] ([WebsiteUrl], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Location_AccountId] ON [dbo].[Users] ([Views], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Location_AccountId] ON [dbo].[Users] ([UpVotes], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Location_AccountId] ON [dbo].[Users] ([Reputation], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Location_AccountId] ON [dbo].[Users] ([LastAccessDate], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Location_AccountId] ON [dbo].[Users] ([DownVotes], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Location_AccountId] ON [dbo].[Users] ([EmailHash], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Location_AccountId] ON [dbo].[Users] ([CreationDate], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Location_AccountId] ON [dbo].[Users] ([DisplayName], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Location_AccountId] ON [dbo].[Users] ([Id], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_Location_AccountId] ON [dbo].[Users] ([Age], [Location], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_Reputation_AccountId] ON [dbo].[Users] ([Age], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Reputation_AccountId] ON [dbo].[Users] ([Id], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Reputation_AccountId] ON [dbo].[Users] ([DisplayName], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Reputation_AccountId] ON [dbo].[Users] ([CreationDate], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Reputation_AccountId] ON [dbo].[Users] ([EmailHash], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Reputation_AccountId] ON [dbo].[Users] ([DownVotes], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Reputation_AccountId] ON [dbo].[Users] ([LastAccessDate], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Reputation_AccountId] ON [dbo].[Users] ([Location], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Reputation_AccountId] ON [dbo].[Users] ([UpVotes], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Reputation_AccountId] ON [dbo].[Users] ([Views], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Reputation_AccountId] ON [dbo].[Users] ([WebsiteUrl], [Reputation], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_UpVotes_AccountId] ON [dbo].[Users] ([WebsiteUrl], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_UpVotes_AccountId] ON [dbo].[Users] ([Views], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_UpVotes_AccountId] ON [dbo].[Users] ([Reputation], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_UpVotes_AccountId] ON [dbo].[Users] ([Location], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_UpVotes_AccountId] ON [dbo].[Users] ([LastAccessDate], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_UpVotes_AccountId] ON [dbo].[Users] ([DownVotes], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_UpVotes_AccountId] ON [dbo].[Users] ([EmailHash], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_UpVotes_AccountId] ON [dbo].[Users] ([CreationDate], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_UpVotes_AccountId] ON [dbo].[Users] ([DisplayName], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_UpVotes_AccountId] ON [dbo].[Users] ([Id], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_UpVotes_AccountId] ON [dbo].[Users] ([Age], [UpVotes], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_Views_AccountId] ON [dbo].[Users] ([Age], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Views_AccountId] ON [dbo].[Users] ([Id], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Views_AccountId] ON [dbo].[Users] ([DisplayName], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Views_AccountId] ON [dbo].[Users] ([CreationDate], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Views_AccountId] ON [dbo].[Users] ([EmailHash], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Views_AccountId] ON [dbo].[Users] ([DownVotes], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Views_AccountId] ON [dbo].[Users] ([LastAccessDate], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Views_AccountId] ON [dbo].[Users] ([Location], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Views_AccountId] ON [dbo].[Users] ([Reputation], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Views_AccountId] ON [dbo].[Users] ([UpVotes], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Views_AccountId] ON [dbo].[Users] ([WebsiteUrl], [Views], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_WebsiteUrl_AccountId] ON [dbo].[Users] ([UpVotes], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_WebsiteUrl_AccountId] ON [dbo].[Users] ([Reputation], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_WebsiteUrl_AccountId] ON [dbo].[Users] ([Views], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_WebsiteUrl_AccountId] ON [dbo].[Users] ([Location], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_WebsiteUrl_AccountId] ON [dbo].[Users] ([LastAccessDate], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_WebsiteUrl_AccountId] ON [dbo].[Users] ([DownVotes], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_WebsiteUrl_AccountId] ON [dbo].[Users] ([EmailHash], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_WebsiteUrl_AccountId] ON [dbo].[Users] ([CreationDate], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_WebsiteUrl_AccountId] ON [dbo].[Users] ([DisplayName], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_WebsiteUrl_AccountId] ON [dbo].[Users] ([Id], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_WebsiteUrl_AccountId] ON [dbo].[Users] ([Age], [WebsiteUrl], [AccountId]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_AccountId_Age] ON [dbo].[Users] ([Id], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_AccountId_Age] ON [dbo].[Users] ([DownVotes], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_AccountId_Age] ON [dbo].[Users] ([DisplayName], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_AccountId_Age] ON [dbo].[Users] ([CreationDate], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_AccountId_Age] ON [dbo].[Users] ([LastAccessDate], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_AccountId_Age] ON [dbo].[Users] ([EmailHash], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_AccountId_Age] ON [dbo].[Users] ([Location], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_AccountId_Age] ON [dbo].[Users] ([Reputation], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_AccountId_Age] ON [dbo].[Users] ([Views], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_AccountId_Age] ON [dbo].[Users] ([UpVotes], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_AccountId_Age] ON [dbo].[Users] ([WebsiteUrl], [AccountId], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_CreationDate_Age] ON [dbo].[Users] ([WebsiteUrl], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_CreationDate_Age] ON [dbo].[Users] ([AccountId], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_CreationDate_Age] ON [dbo].[Users] ([UpVotes], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_CreationDate_Age] ON [dbo].[Users] ([Views], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_CreationDate_Age] ON [dbo].[Users] ([Reputation], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_CreationDate_Age] ON [dbo].[Users] ([Location], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_CreationDate_Age] ON [dbo].[Users] ([EmailHash], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_CreationDate_Age] ON [dbo].[Users] ([LastAccessDate], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_CreationDate_Age] ON [dbo].[Users] ([DisplayName], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_CreationDate_Age] ON [dbo].[Users] ([DownVotes], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_CreationDate_Age] ON [dbo].[Users] ([Id], [CreationDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_DisplayName_Age] ON [dbo].[Users] ([Id], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_DisplayName_Age] ON [dbo].[Users] ([CreationDate], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_DisplayName_Age] ON [dbo].[Users] ([DownVotes], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_DisplayName_Age] ON [dbo].[Users] ([LastAccessDate], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_DisplayName_Age] ON [dbo].[Users] ([EmailHash], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_DisplayName_Age] ON [dbo].[Users] ([Location], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_DisplayName_Age] ON [dbo].[Users] ([Reputation], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_DisplayName_Age] ON [dbo].[Users] ([Views], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_DisplayName_Age] ON [dbo].[Users] ([UpVotes], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_DisplayName_Age] ON [dbo].[Users] ([AccountId], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_DisplayName_Age] ON [dbo].[Users] ([WebsiteUrl], [DisplayName], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_DownVotes_Age] ON [dbo].[Users] ([WebsiteUrl], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_DownVotes_Age] ON [dbo].[Users] ([AccountId], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_DownVotes_Age] ON [dbo].[Users] ([UpVotes], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_DownVotes_Age] ON [dbo].[Users] ([Views], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_DownVotes_Age] ON [dbo].[Users] ([Reputation], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_DownVotes_Age] ON [dbo].[Users] ([Location], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_DownVotes_Age] ON [dbo].[Users] ([EmailHash], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_DownVotes_Age] ON [dbo].[Users] ([LastAccessDate], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_DownVotes_Age] ON [dbo].[Users] ([DisplayName], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_DownVotes_Age] ON [dbo].[Users] ([CreationDate], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_DownVotes_Age] ON [dbo].[Users] ([Id], [DownVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_EmailHash_Age] ON [dbo].[Users] ([Id], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_EmailHash_Age] ON [dbo].[Users] ([CreationDate], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_EmailHash_Age] ON [dbo].[Users] ([DisplayName], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_EmailHash_Age] ON [dbo].[Users] ([DownVotes], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_EmailHash_Age] ON [dbo].[Users] ([LastAccessDate], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_EmailHash_Age] ON [dbo].[Users] ([Location], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_EmailHash_Age] ON [dbo].[Users] ([Reputation], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_EmailHash_Age] ON [dbo].[Users] ([Views], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_EmailHash_Age] ON [dbo].[Users] ([UpVotes], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_EmailHash_Age] ON [dbo].[Users] ([AccountId], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_EmailHash_Age] ON [dbo].[Users] ([WebsiteUrl], [EmailHash], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Id_Age] ON [dbo].[Users] ([Views], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Id_Age] ON [dbo].[Users] ([AccountId], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Id_Age] ON [dbo].[Users] ([WebsiteUrl], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Id_Age] ON [dbo].[Users] ([Reputation], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Id_Age] ON [dbo].[Users] ([UpVotes], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Id_Age] ON [dbo].[Users] ([Location], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Id_Age] ON [dbo].[Users] ([LastAccessDate], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Id_Age] ON [dbo].[Users] ([EmailHash], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Id_Age] ON [dbo].[Users] ([DownVotes], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Id_Age] ON [dbo].[Users] ([DisplayName], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Id_Age] ON [dbo].[Users] ([CreationDate], [Id], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_LastAccessDate_Age] ON [dbo].[Users] ([DisplayName], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_LastAccessDate_Age] ON [dbo].[Users] ([DownVotes], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_LastAccessDate_Age] ON [dbo].[Users] ([CreationDate], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_LastAccessDate_Age] ON [dbo].[Users] ([Id], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_LastAccessDate_Age] ON [dbo].[Users] ([EmailHash], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_LastAccessDate_Age] ON [dbo].[Users] ([Location], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_LastAccessDate_Age] ON [dbo].[Users] ([Reputation], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_LastAccessDate_Age] ON [dbo].[Users] ([Views], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_LastAccessDate_Age] ON [dbo].[Users] ([UpVotes], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_LastAccessDate_Age] ON [dbo].[Users] ([WebsiteUrl], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_LastAccessDate_Age] ON [dbo].[Users] ([AccountId], [LastAccessDate], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Location_Age] ON [dbo].[Users] ([AccountId], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Location_Age] ON [dbo].[Users] ([WebsiteUrl], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Location_Age] ON [dbo].[Users] ([UpVotes], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Location_Age] ON [dbo].[Users] ([Views], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Location_Age] ON [dbo].[Users] ([Reputation], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Location_Age] ON [dbo].[Users] ([EmailHash], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Location_Age] ON [dbo].[Users] ([LastAccessDate], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Location_Age] ON [dbo].[Users] ([Id], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Location_Age] ON [dbo].[Users] ([CreationDate], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Location_Age] ON [dbo].[Users] ([DownVotes], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Location_Age] ON [dbo].[Users] ([DisplayName], [Location], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Reputation_Age] ON [dbo].[Users] ([DisplayName], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Reputation_Age] ON [dbo].[Users] ([DownVotes], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Reputation_Age] ON [dbo].[Users] ([CreationDate], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Reputation_Age] ON [dbo].[Users] ([Id], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Reputation_Age] ON [dbo].[Users] ([LastAccessDate], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Reputation_Age] ON [dbo].[Users] ([EmailHash], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Reputation_Age] ON [dbo].[Users] ([Location], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Reputation_Age] ON [dbo].[Users] ([Views], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Reputation_Age] ON [dbo].[Users] ([UpVotes], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Reputation_Age] ON [dbo].[Users] ([WebsiteUrl], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Reputation_Age] ON [dbo].[Users] ([AccountId], [Reputation], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_UpVotes_Age] ON [dbo].[Users] ([AccountId], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_UpVotes_Age] ON [dbo].[Users] ([WebsiteUrl], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_UpVotes_Age] ON [dbo].[Users] ([Views], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_UpVotes_Age] ON [dbo].[Users] ([Location], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_UpVotes_Age] ON [dbo].[Users] ([Reputation], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_UpVotes_Age] ON [dbo].[Users] ([EmailHash], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_UpVotes_Age] ON [dbo].[Users] ([LastAccessDate], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_UpVotes_Age] ON [dbo].[Users] ([Id], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_UpVotes_Age] ON [dbo].[Users] ([CreationDate], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_UpVotes_Age] ON [dbo].[Users] ([DownVotes], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_UpVotes_Age] ON [dbo].[Users] ([DisplayName], [UpVotes], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Views_Age] ON [dbo].[Users] ([DisplayName], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Views_Age] ON [dbo].[Users] ([DownVotes], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_Views_Age] ON [dbo].[Users] ([CreationDate], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Views_Age] ON [dbo].[Users] ([Id], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Views_Age] ON [dbo].[Users] ([LastAccessDate], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Views_Age] ON [dbo].[Users] ([EmailHash], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Views_Age] ON [dbo].[Users] ([Reputation], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Views_Age] ON [dbo].[Users] ([Location], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Views_Age] ON [dbo].[Users] ([UpVotes], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Views_Age] ON [dbo].[Users] ([WebsiteUrl], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Views_Age] ON [dbo].[Users] ([AccountId], [Views], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_WebsiteUrl_Age] ON [dbo].[Users] ([AccountId], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_WebsiteUrl_Age] ON [dbo].[Users] ([UpVotes], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_WebsiteUrl_Age] ON [dbo].[Users] ([Views], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_WebsiteUrl_Age] ON [dbo].[Users] ([Location], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_WebsiteUrl_Age] ON [dbo].[Users] ([Reputation], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_WebsiteUrl_Age] ON [dbo].[Users] ([EmailHash], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_WebsiteUrl_Age] ON [dbo].[Users] ([LastAccessDate], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_WebsiteUrl_Age] ON [dbo].[Users] ([Id], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_CreationDate_WebsiteUrl_Age] ON [dbo].[Users] ([CreationDate], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_WebsiteUrl_Age] ON [dbo].[Users] ([DownVotes], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_WebsiteUrl_Age] ON [dbo].[Users] ([DisplayName], [WebsiteUrl], [Age]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_AccountId_CreationDate] ON [dbo].[Users] ([DownVotes], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_AccountId_CreationDate] ON [dbo].[Users] ([DisplayName], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_AccountId_CreationDate] ON [dbo].[Users] ([Age], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_AccountId_CreationDate] ON [dbo].[Users] ([Id], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_AccountId_CreationDate] ON [dbo].[Users] ([LastAccessDate], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_AccountId_CreationDate] ON [dbo].[Users] ([EmailHash], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_AccountId_CreationDate] ON [dbo].[Users] ([Reputation], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_AccountId_CreationDate] ON [dbo].[Users] ([Location], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_AccountId_CreationDate] ON [dbo].[Users] ([Views], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_AccountId_CreationDate] ON [dbo].[Users] ([UpVotes], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_AccountId_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [AccountId], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Age_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Age_CreationDate] ON [dbo].[Users] ([AccountId], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Age_CreationDate] ON [dbo].[Users] ([UpVotes], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Age_CreationDate] ON [dbo].[Users] ([Views], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Age_CreationDate] ON [dbo].[Users] ([Location], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Age_CreationDate] ON [dbo].[Users] ([Reputation], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Age_CreationDate] ON [dbo].[Users] ([EmailHash], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Age_CreationDate] ON [dbo].[Users] ([LastAccessDate], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Age_CreationDate] ON [dbo].[Users] ([Id], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Age_CreationDate] ON [dbo].[Users] ([DownVotes], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Age_CreationDate] ON [dbo].[Users] ([DisplayName], [Age], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_DisplayName_CreationDate] ON [dbo].[Users] ([DownVotes], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_DisplayName_CreationDate] ON [dbo].[Users] ([Id], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_DisplayName_CreationDate] ON [dbo].[Users] ([Age], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_DisplayName_CreationDate] ON [dbo].[Users] ([LastAccessDate], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_DisplayName_CreationDate] ON [dbo].[Users] ([EmailHash], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_DisplayName_CreationDate] ON [dbo].[Users] ([Reputation], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_DisplayName_CreationDate] ON [dbo].[Users] ([Location], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_DisplayName_CreationDate] ON [dbo].[Users] ([Views], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_DisplayName_CreationDate] ON [dbo].[Users] ([UpVotes], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_DisplayName_CreationDate] ON [dbo].[Users] ([AccountId], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_DisplayName_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [DisplayName], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_DownVotes_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_DownVotes_CreationDate] ON [dbo].[Users] ([AccountId], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_DownVotes_CreationDate] ON [dbo].[Users] ([UpVotes], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_DownVotes_CreationDate] ON [dbo].[Users] ([Views], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_DownVotes_CreationDate] ON [dbo].[Users] ([Location], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_DownVotes_CreationDate] ON [dbo].[Users] ([Reputation], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_DownVotes_CreationDate] ON [dbo].[Users] ([EmailHash], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_DownVotes_CreationDate] ON [dbo].[Users] ([LastAccessDate], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_DownVotes_CreationDate] ON [dbo].[Users] ([Age], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_DownVotes_CreationDate] ON [dbo].[Users] ([Id], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_DownVotes_CreationDate] ON [dbo].[Users] ([DisplayName], [DownVotes], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_EmailHash_CreationDate] ON [dbo].[Users] ([DisplayName], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_EmailHash_CreationDate] ON [dbo].[Users] ([DownVotes], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_EmailHash_CreationDate] ON [dbo].[Users] ([Id], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_EmailHash_CreationDate] ON [dbo].[Users] ([Age], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_EmailHash_CreationDate] ON [dbo].[Users] ([LastAccessDate], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_EmailHash_CreationDate] ON [dbo].[Users] ([Reputation], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_EmailHash_CreationDate] ON [dbo].[Users] ([Location], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_EmailHash_CreationDate] ON [dbo].[Users] ([Views], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_EmailHash_CreationDate] ON [dbo].[Users] ([UpVotes], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_EmailHash_CreationDate] ON [dbo].[Users] ([AccountId], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_EmailHash_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [EmailHash], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Id_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Id_CreationDate] ON [dbo].[Users] ([AccountId], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Id_CreationDate] ON [dbo].[Users] ([UpVotes], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Id_CreationDate] ON [dbo].[Users] ([Views], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_Id_CreationDate] ON [dbo].[Users] ([Location], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Id_CreationDate] ON [dbo].[Users] ([Reputation], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Id_CreationDate] ON [dbo].[Users] ([LastAccessDate], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Id_CreationDate] ON [dbo].[Users] ([EmailHash], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_Id_CreationDate] ON [dbo].[Users] ([Age], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_Id_CreationDate] ON [dbo].[Users] ([DownVotes], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_Id_CreationDate] ON [dbo].[Users] ([DisplayName], [Id], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DisplayName_LastAccessDate_CreationDate] ON [dbo].[Users] ([DisplayName], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_DownVotes_LastAccessDate_CreationDate] ON [dbo].[Users] ([DownVotes], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Age_LastAccessDate_CreationDate] ON [dbo].[Users] ([Age], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_LastAccessDate_CreationDate] ON [dbo].[Users] ([Id], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_LastAccessDate_CreationDate] ON [dbo].[Users] ([EmailHash], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_LastAccessDate_CreationDate] ON [dbo].[Users] ([Reputation], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Location_LastAccessDate_CreationDate] ON [dbo].[Users] ([Location], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_LastAccessDate_CreationDate] ON [dbo].[Users] ([Views], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_LastAccessDate_CreationDate] ON [dbo].[Users] ([UpVotes], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_LastAccessDate_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_LastAccessDate_CreationDate] ON [dbo].[Users] ([AccountId], [LastAccessDate], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_AccountId_Location_CreationDate] ON [dbo].[Users] ([AccountId], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_WebsiteUrl_Location_CreationDate] ON [dbo].[Users] ([WebsiteUrl], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_UpVotes_Location_CreationDate] ON [dbo].[Users] ([UpVotes], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Views_Location_CreationDate] ON [dbo].[Users] ([Views], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Reputation_Location_CreationDate] ON [dbo].[Users] ([Reputation], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_EmailHash_Location_CreationDate] ON [dbo].[Users] ([EmailHash], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_LastAccessDate_Location_CreationDate] ON [dbo].[Users] ([LastAccessDate], [Location], [CreationDate]) ON psMonthly(CreationDate);
CREATE INDEX [IX_Id_Location_CreationDate] ON [dbo].[Users] ([Id], [Location], [CreationDate]) ON psMonthly(CreationDate);