皮皮学，免费搜题
登录
搜题
【单选题】
You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information: BULK INSERT finance.dbo.customers FROM ‘di/bulk/accts143_10141000.txt’ WITH DATAFILETYPE = ‘char’, FIELD/TERMINATOR = ‘/t’, ROWTERMINATOR = ‘/n,’ TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?A.
Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
B.
Remove the TABLOCK option from the BULK INSERT statement.
C.
Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
D.
Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】因为长得有点胖,他被大家( )为。
【单选题】如图所示,表示五个共点力的有向线段恰分别构成正六边形的两条邻边和三条对角线.已知 F 1 =10 N,这五个共点力的合力大小为( )
A.
0
B.
30 N
C.
60 N
D.
90 N