I thought

SELECT count(1)

FROM mytable

WITH (nolock)

was the preferred method, and certainly easier to remember

Steve, I could not agree with you more.  With all the layoffs over the past 5 years , there are plenty of IT workers to fill jobs.

The popularity of...