Tag Archives: Index Size

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

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