use tempdb;
go

create table dbo.t1
(
 id uniqueidentifier not null,
 LatestManualPostModifiedOn datetime null,
 LatestAutoPostModifiedOn datetime null,
 TypeCode int not null
);

insert into dbo.t1
select top (10000000)
 newid(), getdate(), getdate(), 1
from
 master.dbo.spt_values a cross join
 master.dbo.spt_values b cross join
 master.dbo.spt_values c;

select * into dbo.t2 from dbo.t1;
select * into dbo.t3 from dbo.t1;

alter table dbo.t1 add constraint PK_t1 primary key clustered (Id);
alter table dbo.t2 add constraint PK_t2 primary key nonclustered (Id);

alter table dbo.t3 add row_id int identity not null;
alter table dbo.t3 add constraint PK_t3 primary key clustered (row_id);
create unique nonclustered index IX_t3__id on dbo.t3(id);

select * from sys.dm_db_index_physical_stats(db_id(), object_id('dbo.t1', 'U'), default, default, default);
select * from sys.dm_db_index_physical_stats(db_id(), object_id('dbo.t2', 'U'), default, default, default);
select * from sys.dm_db_index_physical_stats(db_id(), object_id('dbo.t3', 'U'), default, default, default);
go

declare @id uniqueidentifier = (select top(1) id from dbo.t2);

set statistics io on;
select * from dbo.t1 where id = @id;
select * from dbo.t2 where id = @id;
select * from dbo.t3 where id = @id;
set statistics io off;
go

drop table dbo.t1, dbo.t2, dbo.t3;
go