Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Temp table vs Table variable

Author  Topic 

SCHEMA
Posting Yak Master

192 Posts

Posted - 2008-07-28 : 12:40:10
Is it good to use temp table or table variable for 4000 rows?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-28 : 13:15:19
http://www.codeproject.com/KB/database/SQP_performance.aspx
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-07-28 : 13:16:57
I'd be inclined to use a temp table for 4000 rows.

e4 d5 xd5 Nf6
Go to Top of Page
   

- Advertisement -