Technical Article

A new version of RowCount

Hello,Here is a (another one, but improved) stored procedure that returns rowcounts for all tables in the current database, or only for @tablename, if provided. Output can be ordered by name or by number of rows.Improvement : Rowcount is right aligned and formatted with thousand separator.To use it : - open a connection on your […]

2002-07-11

304 reads

Blogs

Daily Coping 21 Jan 2021

By

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

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

How to tell if Change Data Capture (CDC) is working as expected

By

I’m not sure how many of you use Change Data Capture (CDC) on your...

Read the latest Blogs

Forums

Can secondary data file (.ndf) be created by default during sql installation?

By olegserdia

Primary data file, sitting on its own drive, has two files: .mdf and .ndf....

Extended Events stop writing to Ring Buffer in 10 minutes.

By Vladimir Isaev

It hardly goes over 1000 collected rows, and just stops further logging without any...

left join causing results to be multiplied

By profoundhypnotic

Hello, Hello, the query below is giving me some trouble. the results of the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers