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 |
|
jiesheng
Starting Member
1 Post |
 Posted - 2012-06-11 : 05:06:17
|
| Hi Everyone,Does anybody know what's the impact of MSSQL 2008 Database when executing insert and delete SQL statement for around 100,000 records each run after a period of time?I heard from my client saying that for mysql and for its specific data type, after loading and clearing the database for a period of time, the data will become fragmented/corrupted. I wonder if this also happens to MS SQL? Or what will be the possible impact to the database?Right now the statements we use to load and reload the data in to all the tables in the database are simple INSERT and DELETE statements.Please advice. Thank you in advance! :)-Shen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Impact of bulk insertion and bulk deletion