Re: Delete without log ??

From: Lilian Pigallio (lpigallio_at_nospam.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 09:26:53 +0200

It's exactly my case... and after a lot of test I use the TRUNCATE (with
temp tables to keep the data that I need)

1) create table xxx_tmp
2) insert into xxx_tmp from xxx where yyy = zzz and ...
3) TRUNCATE TABLE xxx
4) insert into xxx from xxx_tmp
5) drop table xxx_tmp

"Tony Rogerson" <tonyrogerson@sqlserver.eu.com> wrote in message
news:OCFfJOSvEHA.4020@TK2MSFTNGP10.phx.gbl...
> If the table is 1GB and you do a delete for all the rows then you'll get
> slightly more than 1GB on the log, this can't be truncated (recycled)
until
> the transaction has completed.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://www.sqlserverfaq.com?mbr=21
> (Create your own groups, Forum, FAQ's and a ton more)
>
>

Relevant Pages

  • Re: Instead of DBO
    ... Anyone can create temp table. ... When you say TRUNCATE TABLE, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Delete without log ??
    ... Truncate table will give minimal logging, but that removes all data in the ... (Create your own groups, Forum, FAQ's and a ton more) ...
    (microsoft.public.sqlserver.server)
  • Re: Trucate Command
    ... Insert into temp select * from real_table where date_col between ... Truncate the original table -- This step will ... you can not do any kind of recovery using truncate table command. ... into syntax will look as follows. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Truncating a cell value AFTER the decimal place
    ... If you are always removing the last digit of the value: ... Sub truncateLastDigit() ... temp = ActiveCell.Value ... My understanding of the truncate function is that it will truncate the ...
    (microsoft.public.excel.programming)
  • Truncating a cell value AFTER the decimal place
    ... I haven't found the answer after quickly searching the forum and a VBA ... My understanding of the truncate function is that it will truncate the ...
    (microsoft.public.excel.programming)