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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2003-01-30

267 reads

Blogs

It is Friday, the queries are running, and nobody is watching the bill. That...

Annabel retired from Redgate Software this week. Across most of my career at Redgate,...

As a SQL Server DBA with years of experience tuning production environments, I’ve seen...

Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...

WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311

WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314

When running bcp on Linux, what is the field terminator?