skpani (7/27/2013)
GilaMonster..please make me clear with details..
My recommendation would be to look up "Clustered Indexes" and "Non Clustered Indexes" in Books Online so that you'll at least be familiar with the terms before asking for such help. Just in case you don't know, "Books Online" is the "help" system that comes with SQL Server. In SSMS, press the {f1} key to get there.
Also, did you do as I recommended and look at the code for sp_SpaceUsed?
If you really want to learn something, you have to put your shoulder into it.
--Jeff Moden
Change is inevitable... Change for the better is not.