0
kicks
Back to Basics: Count, Count, Count, Sum or how to Count
There are at least 4 ways you can COUNT in SQL Server: COUNT(*), COUNT(ColumnName), COUNT(DISTINCT ColumnName) AND SUM()
All 4 combined can be used to speed up queries especially for reporting.