SQL SERVER: Why We Should Avoid COUNT (*)

COUNT(*) is commonly used to get total row count of a table/query. COUNT(*) is bit resource hungry method and should be replaced with some performance friendly methods.