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 - 2006-09-26 : 07:37:54
|
| Mike Niemand writes "Hi Team,I have searched for a good answer to this but have no joy. I have a SQL2005 web-based database which stores 100's of clients data in a relational manner across > 15 tables for editing, etc. I recieve an update to a set client data daily. Naturally, I want to update existing records, add new ones and flag deleted records as deleted. I am being told by other developers that this is slow and inefficient and that I must delete all the data pertaining to this client and re-insert it, bearing in mind that my indexes, et al will need to rebuilt and relations to external tables will be poked.Can you advise on this issue, even in point form?" |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-26 : 07:55:46
|
| Delete the client and reinsert? How are you going to maintain the relation nature of the tables? Sounds more inefficient than upserts.I think this came up recently, I'll try to find the post. |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-26 : 07:56:46
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72176&SearchTerms=delete,all,data |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-26 : 13:52:07
|
| Uncanny level of identical phrasing between this post and the original from John Sourcer ... |
|
|
|
|
|
|
Delete / Insert vs Update