You are here: Re: Transform/transfer 50Gb - how to do it fast? « MsSQL Server « IT news, forums, messages
Re: Transform/transfer 50Gb - how to do it fast?

Posted by Mork69 on 05/01/07 09:08

On Apr 28, 4:55 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> This is not correct. INSERT SELECT FROM is a fully-logged operation. You are
> thinking of SELECT INTO which is a minimally logged operation. That is,
> all that is logged are the extent allocations. There are no write operations
> in SQL Server that are entirely non-logged.

Yes, sorry, I was clearly having a bad day, SELECT INTO is what I
meant.

Regarding the statement that it is a "non logged" operation -
obviously all operations write to the transaction log in some way, I
was just using the term that is in general use that was erroneously
started by Books Online. In any case, as the only records that are
written are merely to log a table's creation the difference is
somewhat irrelevant in this context.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация