What is the most efficient, least intrusive, way of getting table row counts (say, for keeping periodic statistics)?    Select(*) is accurate.  Using index statistics is instant but the statistics could be out of date. dm_db_index_physical_stats Dynamic management view.  http://technet.microsoft.com/en-us/library/ms188917.aspx … Continue reading →