SQL Server 2000 temporary table and table variable

Question

Which would be more efficient when storing some temporary data (50 thousand rows in one and 50 thousand in another) to perform the calculation. I will do this process once, at night.

How do you test effectiveness when comparing something like that?

Answer 1

Results will vary, making it easier to store data on disk (#temp) or in memory (@temp).

A few excerpts from the links below

• A temporary table is created and populated on disk in the tempdb system database.
• , #temp ( , ). - tempdb ( #temp- ), .
• .
• [Y] ou .

50k :

/ , #temp

:

• #temp @table?
• MSKB 305977 - SQL Server 2000 -

Answer 2

. , . MVP SQL Server Microsoft . MVP , SMP, ( ) , .

SQL Mag ( , , )

EDIT: CodeProject