Can a partial truncate be done?

Giganews Newsgroups
Subject: Can a partial truncate be done?
Posted by:  deanbrown…@yahoo.com (deanbrown…@yahoo.com)
Date: 19 Jan 2005

I heard some talk of partial truncates, that are fast and avoid all the
role-back delay. Can someone give me a pointer here where to get
started? I heard its an option now in recent versions of server, is
this true?

By 'partial truncate' I mean to remove a selection of records fast,
like a regular table truncate, but leaving other records intact.
Thanks a lot!

Dean

Replies