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 |
|
mrajani
Starting Member
13 Posts |
 Posted - 2009-09-26 : 10:39:42
|
| Hi friends,We have some stored procedures (173 proc) which import data from external system to our data warehouse. Those procedures are written in sql 2000. This import process taking whole night.The steps are as follows...1. Retrieve the recent updated records (last 3months records )2. Dropping indexes on the target table3. adding additional fields apart from the fields importing4. additional manipulations on the imported data5. inserting to target table or updating if the records already exists6. recreating indexesI am given a task to modify the stored procedures in sql 2008 and to improve the performance.What is the best way to increase the performance. What changes I should concentrate from the existing SPs.thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 05:46:28
|
| did you analyse execution plan of procedure to see costly steps? also does source table structure also change (need of step 3??) |
 |
|
|
|
|
|
increase data import performance