Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Dinesh Asanka Temp Tables in SQL Server RE: Temp Tables in SQL Server
kagemaru
SSC Veteran
Points: 258
More actions
July 16, 2006 at 6:01 am
#649429
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