You know that doing COUNT(*) on a table with a lot of columns and a lot of rows can take a lot of time and memory
There is virtually no difference between SELECT(*) and SELECT(1) - the execution plans are identical, and each will produce the same number of logical reads.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience