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)

You rated this post out of 5. Change rating

2003-01-30

246 reads

Blogs

I’ll walk through the KDA UI and tackle the first challenge before diving into...

While I mostly write about SQL Server, I have a soft spot for Kusto....

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Hi Guys, I'm not sure if this is possible or not, but let me...

Comments posted to this topic are about the item Life Moves Pretty Fast

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...