Home Forums SQL Server 2008 SQL Server 2008 Administration I cannot finish COUNT (*) query on a table with more than billion records. RE: I cannot finish COUNT (*) query on a table with more than billion records.

  • September 22, 2015 at 9:23 am

    #1828464

    Why not just check the rowcnt value in sys.sysindexes for the OBJECT_ID(tablename)

    select max(rows) from sys.sysindexes where id = object_id('<table_name>')