shiwani.plrs (9/20/2013)
helloThe Size of my database has been increased to 10-20 GB, although the RAM of my server is quite good, still it takes lot of time to open reports ....is there is any way to reduce the size of database other than using shrink.
thanks
When is the last time you rebuilt/reorged the indexes and when is the last time you updated statistics? I wouldn't mess around with anything else until those two things have been done.
--Jeff Moden
Change is inevitable... Change for the better is not.