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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2011-07-15 : 16:33:41
|
| GreetingsWhen ingesting huge xml files I am using sqlbulxml. It works perfectly! Question now is when dumping literally millions of rows I want to speed things up. It is a straight ingest no validation is happening for foreign key constraints etc. But I have quiet a few indexes on the target tables. What would be the best way to handle performance when using sqlxml. drop and recreate indexes? or any other options?What is the best way to handle indexes when doing bulk inserts?Thanks!If you don't have the passion to help people, you have no passion |
|
|
|
|
|
SQLBULKXML and performance issues