The BCP command in the article omits the table lock load hint. It should read as :
BCP.EXE testdb.dbo.sales IN
f:\\data\\sales.char -S
(local)\\dev -T -c
-b 10000 -h "tablock"


Peter Ellis 8/31/2004 5:59:46 PM

It's a shame that you dont show the charts that appear in the print article.

Peter Ellis 8/31/2004 1:22:22 AM

Confused! Point 4 says to ensure the table has NO indexes to enable minimal logging, yet then this sentence appears: "When you're loading into a table that contains a clustered index, determining whether you're using minimal logging is more difficult." If point 4 is right, it can't use minimal logging. But the results seem to imply minimal logging is possible with a clustered index, thus proving point 4 wrong.

This is a VITAL point to clarify. I'm currently dropping clustered indexes to get minimal logging, but I think it's hurting performance to do so. Should I leave the clustered indexes in place?

Vince Iacoboni 5/6/2004 10:55:26 AM