Re: How to set FILLFACTOR

From: Thomas Kejser (thomas_at_kejser.org)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 14:43:32 +0100

Hi Nags

What utility do you use to load the data into the tables?

In order of load performance the follwing are the best utilities for SQL
2000

- BULK INSERT command
- DTS data pump with the correct settings
- BCP

Though you would expect BCP to perform very good you can gain better
performance by using the BULK INSERT command - it seems that this command
uses the netlib to bulk insert whereas BCP uses OLEDB

Yours sincerely
Thomas Kejser

Relevant Pages

  • Re: How to set FILLFACTOR
    ... we do not use BULK> INSERT at all. ... its> not>> recommended when you have to load a large amount of data. ... >>>> - BCP ... >>>> performance by using the BULK INSERT command - it seems that this ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Bulk insert
    ... bcp does not report any error but does not copy either. ... > check out BCP (bulk copy program) in the BOL ... When i run the bulk insert command as below, ... >> Make sure the field terminator and row terminator are specified ...
    (microsoft.public.sqlserver.programming)
  • Re: Bulkinsert Problem
    ... An alternative approach may me to use the SQL Server Bulk Copy Command ... For more details refer to the "bcp Utility" article in SQL ...
    (microsoft.public.sqlserver.programming)
  • RE: Bulk Copy Question
    ... bcp is a command line utility. ... > I'm trying to bulk copy the syslogins to a text file. ...
    (microsoft.public.sqlserver.server)
  • [usb-storage] USB-Sticks laufen einfach nicht
    ... usb-storage: Transport: Bulk ... GetMaxLUN command result is -32, ... Bulk data transfer result 0x0 ... usb-storage: scsi cmd done, result=0x0 ...
    (de.comp.os.unix.linux.misc)
Loading