things to consider when loading a lot of data to a big table

what are considerations when loading large amount of data large table?

one thing consider indexes because need rebuilt. 1 advice had drop index, load data, , re-create index. faster loading without dropping index?

what other considerations or concerns there? data isolation? if take while load data, users locked out selecting table? try test this, not sure how can come large enough data set play with.

it not faster drop indexes first before loading, because have overhead of rebuilding indexes when done.

please tell version using.

as of sql 2000, there efficient techniques sql server can use internally maintain indexes during bulk load.  should try out own testing.

take @ white paper more details.

the data loading performance guilde:

http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

---

hth, kalen delaney www.sqlserverinternals.com

SQL Server  >  SQL Server Database Engine