> It's saying that nearly all of your data pages are using more than

80% 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.

>
> What it does tell us is that the database has been set up to use all

space. If not, you would see the bulk of your data residing in the
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
inserting?

Kind Regards,

Robert.