How is the easiest way to know how much physical storage the tables in my
database occupy ? I ask this because if I see the space used in the properties of the database
(with Enterprise Manager), I see much more than than what I see using "sp_spaceused
<table>" which I think doesn't say the truth. My database has about 400Gb allocated and
360Gb used. Can you tell me what is the right way to have the space occupied for each table in my
database without having surprises when I go to see the REAL space occupied (which is always much
more)?
Requires Free Membership to View
Open up the stored procedure sp_spaceused. It will give you more than enough information to answer your question.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in July 2002
Join the conversationComment
Share
Comments
Results
Contribute to the conversation