Determine the number of rows in a table without a table scan

By Andrew Novick – If you don’t require an exact answer, it isn’t necessary use a SELECT count(*) query on the rows in a table to get the row count. SQL Server keeps the row count in sysindexes and it can be retrieved there. The key is to select the correct record from sysindexes.

Read More - Register for Free Membership