Posted by Richard Hollis on 10/01/42 11:17

Using BCP with the hints TABLOCK and ROWS_PER_BATCH, what is the best
setting to give ROWS_PER_BATCH? Is it the size of the table you are
importing in rows or a logical division of those rows?

Thanks
Richard

• Next in forum: Re: Help Needed With Job Scheduling
• Prev in forum: Re: Encryption and "WHERE encrypted_column LIKE"
• Thread view: What is the right value for BCP's ROWS_PER_BATCH

[Reply to this message]