title: Dataset Update without Locking SQL Server 40,000+ Rows
body: <p>I am taking a Tab Delimited file from an FTP site and doing a nightly download.  I then upload it in its form using my Dataset.  I simply load it into the dataset and bind it.  It works, but...</p>
  
  <p>I have 2 of these files, and originally I had one working and just did the Inserts of each row by manually pulling all the data out of the file like VB 6.  I assumed the binding of the datatable or dataset in Visual Studio 2012 would use a better algorithm, also I thought it might be easier and more efficient.  It is relatively easy at least.</p>
  
  <p>I do NOT have access to the SQL Server's server file system as it is a shared environment and BULK COPY to SQL Server is not available.  The bulk copy methods of the provider do not work either as advertised, due to my file size.  Obviously, this would be much more efficient.  This I guess is my blue collar way to do it.  I do it nightly for about 100k rows in the 2 feeds remotely Both take about, 45 minutes a piece.</p>
  
  <p>The issue I am having is that the table on this bind, is being locked up so no queries or access can be done while it goes through this 45 minutes of updating.  Again, it does work.  Is there a parameter or setting, I can invoke or set to allow it to be use during this update.</p>