Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Performance Tips Part 1 Expand / Collapse
Author
Message
Posted Wednesday, March 8, 2006 5:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 8:12 AM
Points: 1,307, Visits: 283

In the archiving situation, I think that it is missing a transaction (or else you risk losing log events, between the insert into the archive and the truncate).

I don't agree that it is a one time solution, because you normally archive by year, so every year you create a new table (if it's only for archiving, it's more manageable).

André Cardoso




Post #264097
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse