there is possible performance hit [1]. Also, it could mean that the data granularity has not been modeled well if there are duplicate rows. https://sqlperforma

there is possible performance hit [1]. Also, it could mean that the data granularity has not been modeled well if there are duplicate rows. https://sqlperformance.com/2017/01/t-sql-queries/surprises-assumptions-group-by-distinct https://sqlperformance.com/2017/01/t-sql-queries/surprises-a...