How to find space used by table in SQL Server
Recently there was requirement for a client where we need to find space occupied/used by particular table in SQL Server. I did some research a found a very cool way to get space used information from SQL Server. With SQL server 2005 and higher version you can use ‘sp_spaceused’ to find space used by table