Get row counts and space used for every table
Use the sp_MSforeachtable stored procedure to run the sp_spaceused stored procedure for every table in a database
2003-01-08
105 reads
Blogs
Daily Coping 12 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My Toolbox - Greenshot
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
Daily Coping 11 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSMS: Remove highlight in current cell of grid output
I'm trying to capture some screen shots of query results for documentation. I'd like...
Need to rollup some rows to columns
Hello, thanks in advance for any help. I have a query like this: select...
A way to make this dynamic SQL
Team: Is there an easy way to squeez this sql statement to a...
Ask SSC