Bad habits : Counting rows the hard way

I show some tricks for getting row counts efficiently, and explain why an accurate row count for a large table is a pipe dream.