What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)

by

Here’s how you can disable/enable indexes in SQL Server:

--Disable Index ALTER INDEX [IX_Users_UserID] SalesDB.Users DISABLE
GO
--Enable Index ALTER INDEX [IX_Users_UserID] SalesDB.Users REBUILD

Here are some resources to help you find a solution:

Some bulk loading speed comparisons

Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server

Optimizing Bulk Copy Performance

Definitely look into NOCHECK and TABLOCK options:

Table Hints (Transact-SQL)

INSERT (Transact-SQL)

More Related Contents:

  1. What represents a double in sql server?
  2. SQL Server Char/VarChar DateTime Error [closed]
  3. Delete from two tables? [closed]
  4. How do parameterized queries help against SQL injection?
  5. How to get last inserted id?
  6. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  7. Insert entire DataTable into database at once instead of row by row?
  8. Getting return value from stored procedure in C#
  9. SQL error: Incorrect syntax near the keyword ‘User’
  10. Passing List to SQL Stored Procedure
  11. SQL WHERE clause matching values with trailing spaces
  12. How to retrieve data from a SQL Server database in C#?
  13. SqlBulkCopy from a List
  14. SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance
  15. Any way to SQLBulkCopy “insert or update if exists”?
  16. Multi threading C# application with SQL Server database calls
  17. C# SqlCommand – cannot use parameters for column names, how to resolve?
  18. Received an invalid column length from the bcp client for colid 6
  19. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  20. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  21. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  22. How can I convert ticks to a date format?
  23. Add WHERE clauses to SQL dynamically / programmatically
  24. How to pass string array in SQL parameter to IN clause in SQL
  25. How to insert data into SQL Server
  26. Query validation using C#
  27. Use SQL Server time datatype in C#.NET application?
  28. Generating sql code programmatically
  29. How to give ADO.NET Parameters
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment