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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-18 : 20:04:03
|
pigworks writes "I am currently reviewing a gigantic SQL Server 6.5 that has disgusting temp tables spewed all over the place. The organization tried to migrate to SQL Server 7.0 last year but could not because the query optimizer tried to optimize the selects from the temp tables. They placed tempdb into RAM but this still did not help out. Microsoft reviewed the database and recommended that they wait for SQL Server 2000 and use the table variables.
Anyway, clearly the stored procedures need to be rewritten w/o evil temp tables. However, I'd like to know if there is any way to get temp tables to perform faster. I noticed in one of your postings that 'Select into' with temp tables was slower then using an 'Insert...into' statement. Is this true? Any other thoughts? Also would like to know your thoughts about Microsoft's recommendation not to migrate.
Thanks!" |
|
|
|
|
|
Temp Tables