Home Forums Article Discussions Article Discussions by Author Discuss content posted by Thanh Ngay Nguyen Using T-SQL to Verify Tables Row Counts in Transactional Replication RE: Using T-SQL to Verify Tables Row Counts in Transactional Replication
Thanh Ngay Nguyen
Right there with Babe
Points: 750
More actions
August 5, 2010 at 10:31 am
#1202923
Hi tina.t.kurtluyan
Counting rows in sysindexes is much faster than counting rows in the actual table. However, because sysindexes is lazily updated, the rowcount may not be accurate. If that's the case, you may need to use a full COUNT(*).