the tablock hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the tablelock hint the default more granular row-level lock will be used. This would decrease the scope the locks which would result in less waiting jobs and perfformance would improve.the BULK INSERT satement is used to copy a data file into a database table or view in a format specified by the user. The bulk insert statement accepts the tablock hint, which allows the user to spercify the locking behavior that the bulk insert satatement should use. tablock specifies that a bulk update table-level lock is taken for the duration of the bulk copy. if tablock is not specified, the default uses row-level locks.
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货