• I believe you need to reference the column again on in the partition scheme. Seems redundant, but it does not need to match 100%.

    CREATE CLUSTERED INDEX [ByCreatedWhen_idx] ON [dbo].[SXEvent]

    ([CreatedWhenUTC] ASC )

    On ByCreatedWhen_scm (CreatedWhenUTC)