Alan.B - Tuesday, November 14, 2017 4:36 PM

Please forgive me if I'm misunderstanding what you said but I don't get this:

It's currently a heap with a NC Primary Key, but I feel that it should be clustered to prevent duplication of data.

This will fail:
create table dbo.x (id int primary key nonclustered);
insert dbo.x values (1),(1);

This will not:
create table dbo.y (id int not null);
create clustered index cl_y on dbo.y(id);
insert dbo.y values (1),(1);