-
Personal Links
Verified Services
Top 30 PowerShell bloggers of 2018
https://www.sqlshack.com/top-50-powershell-bloggers-of-2018/#Prashanth%20JayaramMy Blog is ranked amongst the Top 50 SQL blogs worldwide
http://blog.feedspot.com/sql_blogs/DZone MVB
Microsoft
Tag Archives: sp_msforeachtable
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance. There are many ways to get the result. This post gives you an idea and SQL in which undocumented SP’s being called “sp_MSforeachdb and … Continue reading
Posted in sp_MSforeachtable, SQL, T-SQL
Tagged @whereand, get record count of all database into temp table, rebuild all indexes, sp_msforeach like clause, sp_MSForeachdb, sp_MSforeachdb and sp_MSforeachtable examples, sp_msforeachtable, sp_msforeachtable if clause, SQL, total record count, Total rows
1 Comment
SQL – List All Tables, Space Usage Info & Other Details
One of the OP requested in the forum to find all table details of any database. The details which includes Number of Rows,table size, index size etc:-. Even I frequently writing queries to list all such details. I’ve used SQLCMD mode to … Continue reading
Posted in Uncategorized
Tagged Index Size, No Of Rows, sp_msforeachtable, sp_spaceUsed, SQLCMD, Table Size
Leave a comment
Prashanth Jayaram 