Well yes :-)
The bigger of the two database has been more active. I mean, the one
database is a production database, so activity on that one is minimal. and
the other database is the development database. a lot more activity because
of testing, and development, etc...
The development database is bigger that the production database. I am not
talking about log files, just the .mdf files
> Well, so what did you mean
> <The bigger database has been worked on a lot more.> ?
> > Thanks
> > Well i am not worried about performance, its more of an issue of
> > This database gets packaged - and smaller is preferable.
> > It's not the transaction log that is getting huge, and there is no extra
> > space in the data file. (to answer the other post)
> > Jason
> > > Jason
> > > It should not be any differnce with perfomance on big size or small
> > > databases
> > > You did mention that both databases containt the same amount of data
> > > I actually have two databases with the same amount of data but
> > size
> > > So when i run two queries (identical)on these databases i did not see
> > > difference with perfomance.
> > > Also when you create a new database try not specify automatic growth ,
> > > we want to minimize how often automatic growth occurs. One way to help
> > > this is to size the database and transaction logs as accurately as
> > possible
> > > to their "final" size. Sure, this is virtually impossible to get
> > > right-on-target. But the more accurate your estimates (and some times
> > > takes a some time to come up with a good estimate), the less SQL
> > will
> > > have to automatically grow its database and transaction logs.
> > > > Hi
> > > > Is there any other way to make a database size smaller (megabytes)
> > > > than to do the "all tasks, shrink database" route?
> > > > Reason i ask, is because i have two database with the same content,
> > > the
> > > > one database is twice the size of the other...
> > > > The bigger database has been worked on a lot more.
> > > > I have deleted the log files, so i NEED to get the actual MDF file
> > in
> > > > size
> > > > Thanks
> > > > Jason