In an extensive database, tables use much space in SQL Server, and sometimes you don't know that until you check. This blog will run through the query to identify used space with the following data.
- SchemaName
- TableName
- TableType.
- FileGroupName
- NumberOfPartitions
- NumberOfRows
- TotalDataPages
- SizeOfDataPagesKB
- NumberOfIndexes
- NumberOfIndexPages
- SizeOfIndexPagesKB.
You can execute the query on the required SQL Database ,https://github.com/rajendragp/RajendraScripts/blob/master/SpaceUsedbyTables.sql, and it gives the following data.
