• 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 is the same in SQL Server, the true advantage of the SELECT INTO is here, not elsewhere