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 - 2001-02-15 : 18:53:16
|
Bhavna writes "In my company We maintain inventories of our customers. Daily we have to delete and than insert around 1500000 rows in four approx 22000000 row tables It takes around 6.30 hours to delete rows from those tables and around 8 hours to insert in those tables.I want to know is there any way by which processing time can be reduced ?
version :mssqlserver 7 sp 2
OS : windows 2000" |
|
|
|
|
|
Large deletes