Tag Archives: sp_spaceUsed

SQL Server – Internals of sp_spaceused

This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage internals and the growth trends play a vital role in the defining the right sizing of the database. sp_spaceused is probably an administrator’s … Continue reading

Posted in SQL | Tagged , , , , , , | Leave a comment

Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs

For more Information refer Technet Article Introduction sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The … Continue reading

Posted in SQL | Tagged , | Leave a 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 , , , , , | Leave a comment