Hi, Could I please ask for your help to get an SQL query that I can run so it can provide the below stats?
I would like to be able to run the sql query for multiple databases. Several times a week too. But no stored procedures, as I do not have the privileges to run them and will never get permission to run them.
Database: database1 Table1 - 500,000 records Table2 - 120,000 records Table3 - 50,000 records Total Records - 670,000 Table Size - 1234 Database Size - 12GB
And other metrics that you may think is ideal to have.
When the data is needed, then a clean approach should be used. Thus creating a a stored procedure collecting those data. Cause firing a gazillion of ad-hoc queries against your databases isn't a good idea.