Get fast-rowcount for all tables in a database

This little query gives the table name and rowcount for each table in the database that its run.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

2003-01-30

242 reads

Blogs

New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

I'm pretty new a creating JSON output form SQL server. I'm having trouble with...

I'm looking for some suggestions on how to create a delta file that will...

Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful as...