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
104 reads
Use the sp_MSforeachtable stored procedure to run the sp_spaceused stored procedure for every table in a database
2003-01-08
104 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...
By James-Serra
I sometimes get asked from customers if they should use a star schema or...
I am trying to get data from myslq into mssql with ssis. I am...
how to check which job or stored procedure using xp_cmdshell in sql server ?
i need to configure job to consolidate sql error log sizes from multiple servers...