Ever wonder how big a table really is in your database?
You know there are a million rows in the table, but how much space is that really taking?
Syntax:
sp_spaceused ‘Tablename’
Here’s an example of it in action: Highly useful stuff.
It’s always interesting to see that the indexes are bigger than the actual data.
