reserved space on an sql server table

Hi Folks,

In sql server 2005 There is a standard report called Disk Usage by top tables. There is a column in this report called reserved space KB (of a table). What determines how much space is reserved for a database and can it be modified?
david_32Asked:
Who is Participating?
 
cdaly33Connect With a Mentor Commented:
There is a growth percentage put in place when creating a new database.  In SQL Server Management Studio when you create a new database there is a field for the initial size and one for the Autogrowth of the database.  In this way SQL doesn't need to keep expanding the database every time a record is inserted.  As a best practice a DBA should create a database at an initial size that is around what the anticipated size of the database will be.  This size is usually determined by experience with other databases and guessing at how much growth the new database will have.
0
 
cdaly33Commented:
I believe its based on previous space allocated for data that was in the table at one point.  If you want to get rid of some of the space the easiest way it to do a db file shrink.  Usually though, unless you really really need the space back its best just to leave it alone.  MS SQL decides how much room it thinks it needs for table.
0
 
david_32Author Commented:
how come for a new database the reserved space is not 0?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.