Niben M Singh wrote:

>
> MyDB.XXX
> --------------
> Data Pages = 23877
> Avg.Fill = 55%
> Pages with 20-39% Fill = 1
> Pages with 40-59% Fill = 23876
>
> MyDB_2.XXX
> --------------
> Data Pages = 14101
> Avg.Fill = 94%
> Pages with 20-39% Fill = 1
> Pages with 79-99% Fill = 14100
>
> This seems like similar to restoring database with -use_all_space option.
>
> Is there any ramification of using this restore option for

database that is used for read only for the most of the time with
very occasional insert/update/deletes? It sure seems to make size of
the database small and SELECTs faster.

>

If the database is strictly ReadOnly then use_all_space should be a
good thing. However, when inserts and updates happens there will
soon be a need for creating new pages (probably for both data and
indexes). This is (relatively) time consuming.


--
Aage J.