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.

[Back to original message]