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!

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

spt_values "low"

Status
Not open for further replies.

jhall01

Programmer
Jul 3, 2003
328
US
What does this column hold?

I am using a query to track my table sizes and I take the low field from the spt_values table and divide it by 1024 to monitor table growth.

I have noticed that sometimes I insert several thousand records and the size of the table decreases. I have also noticed that when I upload a huge amount of records the table jumps up in size but the next day it drops a little bit.

could someone explain why this is happening?

I do have indexes on these tables.

Thanks,

Jon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top