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 |
|
empyrean
Starting Member
14 Posts |
 Posted - 2010-11-01 : 14:15:27
|
| Hi i have a question in sql server.. we had a dts package which runs everynight to get the records, here it was set up in such a way that it first clears the tables and then it download the entire data to server from another server. one table has 8 million records and another 3-4 tables has 4 ot 5 million records.. i believe updating the table every night is good way to do.. but when i talk to my colleague, i was told that updating will take more time as it has to match each and every item and see so we do clear and reload. is that true?? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-11-01 : 14:44:49
|
| It depends on many things, including how many of the rows would actually be updated.The only way to know for sure is to test it.CODO ERGO SUM |
 |
|
|
|
|
|
Clear and Reload or Update Tables