|Re: One table taking a long time to insert/update
> It's saying that nearly all of your data pages are using more than80% of the space on them. Of course, it doesn't say what's on those
pages - there could be a lot of garbage, for example, which would tend
to kill performance.
>space. If not, you would see the bulk of your data residing in the
> What it does tell us is that the database has been set up to use all
60 - 79% (or lesser) zones. Normally you would only do this with a
read-only database, with a view to shipping a slightly smaller file on
some transportable medium.... it's not an optimal way to configure a
database that's going to be maintained.
>Hi Helen so how do you configure database to leave more space while