SRP0003.md

SQL Server Rule: SRP0003

Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Performance
Class	DoNotUseDistinctInAggregatesRule

Rule Information

Id	SRP0003
Friendly Name	Aggregate of unique set
Category	Performance
Ignorable	true
Applicable Types	Procedure
	Scalar Function
	Table Valued Function
	View

Description

Avoid using DISTINCT keyword inside of aggregate functions.

Summary

Avoid using DISTINCT keyword inside of aggregate functions.