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 |
|
nbkr3bi
Starting Member
15 Posts |
 Posted - 2007-05-16 : 01:57:41
|
| We have a stored proc which takes data from a database D1 (multiple tables) and inserts it into a temporary table variable. (DECLARE @Table TABLE( .... )Then we insert the data from this @Table and insert it into different tables in database D2Finally there is a select statement that does a join on all the tables in D2 and displays it.This proc is timing out quite often and we need to tune it to reduce the timeouts.Any suggestions? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-16 : 02:00:02
|
| How can we suggest improve unless you show us your code?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
nbkr3bi
Starting Member
15 Posts |
Posted - 2007-05-16 : 02:17:40
|
| Unfortunately i cant do that as its against the policy.I was looking as getting some suggestions regarding the approach that is followed and if there is a better, more efficient way of doing the same |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-16 : 02:53:54
|
| "Unfortunately i cant do that as its against the policy"You won't get much help then.Why not globally change all the names to MyTable1 / MyCol1 etc.?Kristen |
|
|
|
|
|
|
Stored procedure performance