CREATE TABLE [dbo].[test](
	[Time] [datetime] NOT NULL,
	[ID] [uniqueidentifier] NOT NULL,
	[Location] [geography] NOT NULL,
 CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED 
(
	[Time] ASC,
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO

ALTER TABLE [dbo].[test] ADD  CONSTRAINT [DF_test_ID]  DEFAULT (newid()) FOR [ID]
GO