Posted by Thyagu on 05/22/06 15:20

Hi,

Does a database restoration perform any
update-statistics/defragmentation by default. We observed a marked
improvement in performance when we restored the a database from an high
end machine to a low machine.

Could someone shed some light on this.

Regards,
Thyagarajan Delli.

• Next in forum: eternal lock?
• Prev in forum: Re: how to insert data into to image datatype
• Thread view: Effects of a Database restoration.

[Reply to this message]