brainy (2/21/2011)
But most of the people will think bcp will not be logged where as a simple insert command will log, that's why bcp is fast and dont eat disk space while insertion.
I've not seen too many people assume that bcp isn't logged. If fact, if the DB is in full recovery, it'll be logged much like a normal insert
But the fact is bcp will do same inserts in batches or chunks so we dont see much usage of disk(logfile) even we are inserting huge data.
Not necessarily. If the DB is in full or bulk-logged recovery and a log backup doesn't run between the batches, the log can grow. bcp is minimally logged in bulk-logged and simple recovery, not in full recovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability