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
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