Estimating the table size...

Well.... it's bit lengthy; I have used 6 functions to get the table size. Table size returned is in KB.

1. fn_CalculateHeapSize: This function calculates the size of heap i.e when no clustered index has been defined.
2. fn_ClusteredIndexSize: This function calculate the clustered index size.
3. fn_GetNonClusteredIndexSize: This function calculate the size of all non-clustered index.
4. fn_GetTableSize: This function combines the result of above functions to give the final results.
5. fn_getIndexSpace: A common function used for calculation in above functions.
6. fn_GetLeafLevelIndexSpace: A common function used for calculation in above functions.

• Usage: select dbo.fn_GetTableSize('tablename')

Note:

I have not considered the LOB cols. in my calculations; also this is an estimation of a table size as given in BOL "Estimating the table size"