Effect of Indexes (on a database table's Size)

sp_spaceused
-----------------
sp_spaceused in Sql Server can be used to find a table's size.
Comparing a table's size before & after creating an index can be done using it.