May 6, 2009 at 8:31 am
I was told that the database have lots of white space in the table and I need to clean it. Why is it happening and how can I clean it and how can I find out which table?
Thank you
May 6, 2009 at 8:55 am
You'd have to get more details from someone. There might be whitespace in fields if you have char instead of varchar fields.
If they mean you have more space in your data file than data you should. Your database should have enough free space for 1-6 months worth of data growth. And as it gets filled, you manually add more space.
May 6, 2009 at 10:19 am
I was told to check everything and I can't get any info from others only on my own.
When you say
char instead of varchar fields, why? How can I check if
I have more space in my data file than data I should. How do I know if my database should have enough free space for 1-6 months worth of data growth.
Thank you
May 6, 2009 at 10:22 am
If you look at the properties for a table, you'll get a list of the fields.
If you look at the properties for a database, there is a "size" and a "space available"
As far as how much you need, no idea. You'll have to watch those values over time and see how much the data is growing.
You can expand the space on the 2nd tab of the database properties.
May 6, 2009 at 10:38 am
Thank you, but why char instead of varchar fields, why?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply