COUNT(*) is absolutely the right way and COUNT(1) doesn't mean or do anything different other than cause confusion. If it was somehow better and yet returned the same results,...
What a useless article. It's full of misinformation and bad practice (SELECT TOP 1 id from #temp) won't even work reliably. There is no reason on earth to...