This email was created by [your name] who thought you would be interested in the following Article:
"Number of different ways to get total number of rows from tables"
Getting a SQL Server RowCount Without doing a Table Scan
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!