SQL Query Optimization: Choosing Between COUNT(*) and COUNT(1)

Question

I recently got into a discussion about whether it's better to use COUNT(*) or COUNT(1) in SQL queries. Does it make any difference in terms of performance?