Reserved space

• krishna83

  Ten Centuries

  Points: 1003

  More actions

  May 23, 2017 at 7:51 am

  #330618

  Does it reconmmended to release reserved space of a table?

  I have a table with  reserved space two times morethan data.

  Thanks & Regards
  Krishna.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  May 23, 2017 at 9:05 am

  #1943819

  krishnabudampati - Tuesday, May 23, 2017 7:51 AM

  Does it reconmmended to release reserved space of a table?

  I have a table with  reserved space two times morethan data.

  Thanks & Regards
  Krishna.

  Not necessarily. Did you get the reserved space and data space using sp_spaceused? If you did, did you check the unused space?

  Sue