| Ken Abe 2006-01-26, 4:53 pm |
| BOL for SQL 2005 describes how to achieve minimal logging by switching to
bulk-logged or simple recovery mode:
http://msdn2.microsoft.com/en-us/library/ms190422.aspx
Do these rules apply to using SSIS "Import/Export Data"? In other words, is
this utility a bulk import utility, or is it something different with its own
set of rules? How about the DTS equivalent in SQL 2000?
In the following questions, I'm assuming that logging has a big impact on
speed when loading data. Given the above rules about data page logging and
index page logging, which is faster between:
(1) bulk inserting a large amount of data into a table and then creating an
index
(2) creating the index first and then bulk inserting the data
Is the answer different for clustered and non-clustered indexes? How about
whether or not the table is empty?
Right now, I'm learning about this stuff through trial and error, but
insight/explanations from an expert would be very welcome.
|