Stackify_Blog_Post_Snip_CreatePartitionedTable.sql

CREATE TABLE [dbo].[Imagination_Partitioned](
	[Partition] [smallint] NOT NULL DEFAULT [dbo].[udf_GetDayOfTheYear](DEFAULT),
	[Id] [int] NOT NULL,
	[DateUtc] [datetimeoffset](7) NOT NULL,
	[Value] [int] NOT NULL
 CONSTRAINT [PK_Imagination_Partitioned] PRIMARY KEY CLUSTERED 
(
	[Partition] ASC,
	[Id] ASC
)ON ps_DayOfTheYear (Partition)
)