Hello Willie,

you're right, the result from sp_spaceused might differ from the query, since the query itself doesn't add xml indexes or fulltext indexes for the given table, in contrast to...

After putting together the previous query, I came along this undocumented sp:

sp_MSIndexSpace tablename

which also returns the sizes for each single index. Just in case anyone's looking for that... 🙂

While trying to find more about sizes of specific indexes, unlike the sum of used space as returned with sp_spaceused, I changed the queries used by sp_spaceused a bit...