title: Size of a single Record ? SQL
body: <p>I have a scenario where every user has been allocated 2 MB of database space.
  Now I have to show Percenatge usage of their allocated space, to do so I need to know the size of single record in the Table.</p>
  
  <p>I have tried to use sp_spaceused and even wrote a custom procedure making use of datalength .. but they show vast difference in their result.</p>
  
  <p>Is there any way around to get this thing right.</p>