Posted In: records count

Get record count of large or locked tables in MSSQL

Ever wondered why it takes so much time to get the count of rows in an SQL table with millions of records? In case when the table is large and fragmented the 'select count(*) from large_table_name' may take seconds to minutes to return an output. Re-indexing can also take up considerable

This Article is TAGGED in count, count of large tables, Large Tables, locked table rowcount, MS SQL Tables, records count, rowcount sql, sysindexes. Read more