oops sorry, I was mislead by related posts to this morning article, I did not notice the post date.

check the SSC headline from today, there is a good explanation on this topic

Hello,

I have not waited XML to put a word document between two ###VERYLONGDOCUMENT### and tell my remote client to use these tags to decode. XML is an xtremely marketed language...

To avoid to mislead all the readers of this article, I think it can be clearly claimed that in any case, for fast temp table creation, SELECT INTO is the...

I think it is a wrong way to create "temp" tables in user databases, especially is the database is in the full reco mode because the transactional coherency is lost...

I believed, as it is in Sybase, that SELECT INTO avoided logging operations : all the rows created by select into are not written to the tempdb log. If it...