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.

http://www.sukesh-marla.com/2010/10/which-is-best-way-to-count-number-of.html