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-09-25 : 22:13:25
|
| vidya writes "Hi,We have a table (say Table B) that contains millions of records. The table is linked to a parent table (Table A). The records that to be deleted are marked for deletion in the main table.When we try to delete records from Table B with an inner join on Table A then the query fails resulting in Timeout expired error.We tried batch deletion but does not improve the performance any better.The tables have been indexed.If there is any better method then please do share it.ThanxVidya" |
|
|
|
|
|
Deleting thousands of rows