When I run the profiler, the 'simple' stats include two different counts: one for "unique" values and the other for "Distinct" values.
I don't understand the difference between them.
Can someone please explain how I should interpret the case when:
Row Count = 658,645 (OK, I think I understand this one )
Null Count = 0 (I understand this one too )
Distinct Count = 5,097
Unique Count = 541
Duplicate Count = 4,556