All tablename and Record Count in a Database

Hello,Here is a way that help in getting all the table name and rowcount with in a database The use can give the database name and it will show the output for that database.Output can be ordered by name or by number of rows.To use it : Copy the script and run paste in QA […]

2005-11-14 (first published: )

117 reads

Blogs

How to get the Active Directory user password policy values

By

Recently I have had to troubleshoot quite a bit of SQL login issues and...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

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...

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...

How does DBCC CHECKDB use tempdb?

By RaufDBA

I would like to know the working principle of DBCC regarding the tempdb. I...

Minimum memory

By WhiteLotus

Hi All , Should we adjust the minimum memory per query (in KB)  in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers