Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_spaceused results

Status
Not open for further replies.
timscronin

timscronin

MIS
Jun 27, 2001
837
US
When looking at the values sp_spaceused returns for a table, do I add data and reserved to see how much space, or is reserved the total amount of space used by the table
 
Sort by date Sort by votes
Reserved is total space taken up. Data is how much actual space data is being used. You can also have indexs and unused space.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CajunCenturion
  • Locked
  • Question
OpenRowSet returns same results even if source table changes
Replies
2
Views
87
CajunCenturion
CajunCenturion
aomara
  • Locked
  • Question
Distortion of the "@query" results in "sp_send_dbmail" HTML
Replies
2
Views
64
aomara
aomara
ksbrace
  • Locked
  • Question
email results from stored proc 1
Replies
6
Views
48
mrdenny
mrdenny
icemel
  • Locked
  • Question
sp_spaceused output
Replies
4
Views
32
mrdenny
mrdenny
JohnOB
  • Locked
  • Question
Exporting Query Results to Excel 1
Replies
1
Views
34
Catadmin
Catadmin

Part and Inventory Search

Sponsor

Back
Top