Finding no. of Rows in all tables of a datbase in one line of script
Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table
2011-01-11 (first published: 2010-12-22)
2,448 reads
Blogs
Daily Coping 28 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The DBA as a helpdesk.
Every one and again you will see people asking What skill do you think...
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Update table FirstName & LastName from Email addresses
I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...
SQL Instance Aliases - Urgent assistance needed please
I have a migration problem. I cannot get my SQL Server instance aliases to...
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
Ask SSC