Best way to count number of records in a table using SQL

In this blog, the author talks about the best way to count number of records in a table.