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 |
|
Zhaker
Starting Member
1 Post |
 Posted - 2005-11-16 : 19:39:35
|
| I am currently doing a Transaction for a variety of updates and insertions to the database. But unfortunately, anything involving single inserts to a temporary table, or a creation of a temporary table, seems to make the transaction slower than without needing the transaction.Unfortunately for this transaction to work I need the temporary tables to be inserted a number of times while using the temporary tables to do other insertions or updates on to other existing tables that will be used for transaction.Is there anyway to speed up the transaction without me needing to put in the single inserts outside the transaction as that is not going to be possible? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-17 : 00:48:20
|
| Hi Zhaker, Welcome to SQL Team!I get the overall gist of what you are doing, but can you post the SQL code for us to have a look at please?Kristen |
 |
|
|
|
|
|
SQL Performance Issues