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
109 reads
Use the sp_MSforeachtable stored procedure to run the sp_spaceused stored procedure for every table in a database
2003-01-08
109 reads
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Hi everyone, We recently upgraded our server to Sql Server 2019 (15.0.2125.1 (X64) on...
Hi Dbatools is used to copy table data from domain a to domain b...
I am using the following sql to convert rows into columns for each pid,...
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers