I talk about an inefficient but common use case for DISTINCT: removing extra rows from joins.

Over a decade of posts and videos involving bad habits and best practices in SQL Server.