Tag Archives: total rows

Approximate total rows in SQL Server database

Posted on February 3, 2011 by Clint

Here is a script that approximates the total rows in your SQL Server 2005+ database. It’s approximate because it comes off sys tables which are not updated constantly. SELECT [TableName] = so.name, [RowCount] = MAX(si.rows) FROM sysobjects so, sysindexes si … Continue reading →

Posted in SQL | Tagged | Leave a comment