INT
PK, and made the NVARCHAR(64)
PK a non-PK, and kept it, I would still not really gain much (I don't think) because literally every query has a WHERE Name = @Name
and that Name
is the PK now, and even if I made a new PK as an INT
it would still always be WHERE Name = @Name
in the query, because I reference all these items by their name, and they're frequently referenced.