312 Part I EXAM PREPARATION TABLE 5.4 BCP
312 Part I EXAM PREPARATION TABLE 5.4 BCP BULK INSERT HINTS Hint Description ORDER (column This hint enables you to tell SQL Server in what ASC|DESC, column…) order the data is coming through. If the data is in a specific order and clustered indexes are on the table, this option makes the inserts go faster. ROWS_PER_BATCH=bb This is the number of rows per batch. You can also specify this using the -b option. Don t use both. KILOBYTES_PER_BATCH=cc This is the number of kilobytes to put into each batch. Similar to rows per batch, but you can specify the amount of data to put into each batch. TABLOCK This causes SQL Server to put an exclusive lock on the entire table for the duration of the load. This significantly increases performance. You can turn on the Table Lock On Bulk Load option for a given table using sp_tableoption and get the same effect. CHECK_CONSTRAINTS This tells SQL Server to apply CHECK constraints as it inserts data. Causes a huge performance hit, but this is not the default, so if you need to check your constraints as you go, use this. FIRE_TRIGGERS This tells SQL Server to fire any triggers that are created for INSERT. By default, INSERT triggers are ignored for bulk copy. Here is an example of using BCP to put data into a database: C:Documents and SettingsMILLCS>bcp Chapter5..Sales in .salesnative.dat -n -T Starting copy… 8 rows copied. Network packet size (bytes): 4096 Clock Time (ms.): total 1122 C:Documents and SettingsMILLCS> If more than 1000 rows were being copied, BCP would supply a running count of the number of rows inserted.
For reliable and cheap web hosting services please check tomcat web hosting website.