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 |
|
MevaD
Starting Member
32 Posts |
 Posted - 2010-05-06 : 17:45:07
|
| I am refreshing data (about 20,000 rows) in a table every hour. Is it better to:1. Delete the existing data and insert newOR2. Drop the table, recreate it and then insertThanks for any (good) advice :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MevaD
Starting Member
32 Posts |
Posted - 2010-05-06 : 17:59:56
|
| OK, got it - thank you.-MD |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Clear Table or Drop Table
Tara Kizer