Removing Audit History - SQL School Video

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Removing Audit History - SQL School Video

Removing Audit History - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Monday, March 09, 2009 11:56 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the item Removing Audit History - SQL School Video

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #672178

Adrian Hains

Posted Thursday, March 12, 2009 9:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 01, 2012 1:18 PM
Points: 110, Visits: 261

If your trim job has any significant number of rows in it, it is generally advisable to expire the rows in batches of N rows. One very easy way to implement this is to do:
set rowcount @pBatchCntDelete -- Limit number of rows to select
and then run the delete in a loop until no rows are affected.

Of course it will perform far better if you can base your deletions on the clustered key. If you aren't using an index and have to delete by table scan, then you would not want to batch the delete as above.

Post #674382

« Prev Topic | Next Topic »

Permissions