May 27, 2005 at 8:11 am
I appreciate if some body can tell me how to tune the temp tables.
Thnaks,
Sree
Thanks,
SR
May 27, 2005 at 8:16 am
Can you tell us in what situation?
May 27, 2005 at 10:36 am
You can create indexes on Temporary tables and place TempDB on a separate filegroup/drive for performance.
May 27, 2005 at 2:56 pm
I agree with the above poster that more background is needed; but you might consider using the table datatype if you are in a SQL 2k environment and are getting a lot of recompiles with stored procedures currently using temporary tables. SP's using table datatypes experience fewer recompilations and, since they are memory resident, require no space in TempDB at all.
Regards - Cris
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply