[dba-SQLServer] SELECT INTO Versus CREATE #temp

Arthur Fuller fuller.artful at gmail.com
Fri Jul 18 10:14:06 CDT 2008


I just complete my test case and the difference on inserting 100 rows was
less than one second. Hardly worth a rewrite.

Arthur

On Fri, Jul 18, 2008 at 11:05 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> I guess maybe I can only find out by writing a test case that inserts 1K or
> 10k rows. None of the instances of such code impose any constraints, so it
> may be 6 of one and 1/2 dozen of the other. Maybe they both resolve to
> identical code beneath the covers; maybe not. I'll write my test case and
> report back with the results.
>
>



More information about the dba-SQLServer mailing list