我是否应该设计一个带有varchar或int的主键的表?

I know this is subjective, but I'd like to know peoples opinions and hopefully some best practices that I can apply when designing sql server table structures.I know this is subjective, but I'd like to know