I've had situations where there was a large feed I was taking in that basically overwrote a table in the db. This tabled information was queried a lot.
If Sql Server uses memory to store the queried data wouldn't it be better if I just updated rows instead of overwriting a table.
Is there a penalty for:
- dropping a table and rewriting it
- or just truncating it and pushing new rows into it
- or focusing on updating only dirty rows?
What would be the preferred method?