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

297 reads

Blogs

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Using volumes in SQL Server 2019 non-root containers

By

I’ve seen a few people online asking how to use docker named volumes with...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

missing storage space

By MVDBA (Mike Vessey)

Hi I have a particular drive on one of my sql servers, it's gotten...

Issue with processing dimensions

By richardmgreen1

Hi all   I've got a weird one here. We have a multi-dimensional cube...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers