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 |
|
prema1511
Starting Member
1 Post |
 Posted - 2010-01-12 : 05:49:27
|
| what is the best way to increase data vol in SQL 2000 database consisting 100 M records.It takes 15 days currently.i am increasing the data volume in a SQL database consisting of 100 million records. I ran a script to pull out records from a table matching a particular code to a temp table, update the code to a different one and again update the new set of records to the same table. This way i do for 60 tables. i use cursor for iterating the dependant tables and while loop for iterating codes. Totally i need to replicate for 100 codes in 60 tables. Currently the script is taking 15 days to complete for 100 codes. If anyone can suggest a different method for doing the above said procedure it would be very useful. my email id is premaattcs@gmail.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 05:53:36
|
| are you trying to apply delta changes from one db to tables in another db? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-12 : 06:18:16
|
| Test data maybe?Is the database properly managed? e.g. index rebuilds / rebuild statistics etc. Can't see that adding 100 sets of codes in 60 tables can take 15 days normally - but it would / could if the "shape" of the database was not optimal.Test data bases often don;t have those jobs run, and that can lead to slow running |
|
|
|
|
|
|
Performance tuning of SQL query