Posted by MJKulangara on 02/02/06 23:04

generally truncate table xxx ...will be MUCH faster than delete. Be
aware of some of the logging issues associated with truncate table
before you do this. Search your BOL for "truncate table".

MJKulangara
http://sqladventures.blogspot.com

• Next in forum: Re: Performance and data structure question
• Prev in forum: Re: Monthly date range substitution
• Thread view: Re: Deleteing large bulks of data

[Reply to this message]