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

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)

Related Contents:

  1. What represents a double in sql server?
  2. How do parameterized queries help against SQL injection?
  3. How to get last inserted id?
  4. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  5. Execute Insert command and return inserted Id in Sql
  6. Adding multiple parameterized variables to a database in c#
  7. Insert entire DataTable into database at once instead of row by row?
  8. Getting return value from stored procedure in C#
  9. How can I convert ticks to a date format?
  10. Passing List to SQL Stored Procedure
  11. SQL WHERE clause matching values with trailing spaces
  12. SqlBulkCopy from a List
  13. SQL error: Incorrect syntax near the keyword ‘User’
  14. Query extremely slow in code but fast in SSMS
  15. How to retrieve data from a SQL Server database in C#?
  16. SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance
  17. Code to validate SQL Scripts
  18. MultipleActiveResultSets=True or multiple connections?
  19. SQLException : String or binary data would be truncated
  20. Any way to SQLBulkCopy “insert or update if exists”?
  21. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  22. How to give ADO.NET Parameters
  23. What is passing parameters to SQL and why do I need it?
  24. Capturing count from an SQL query
  25. SqlConnection.Close() inside using statement
  26. Multi threading C# application with SQL Server database calls
  27. Generate class from database table
  28. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  29. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  30. Add WHERE clauses to SQL dynamically / programmatically
  31. How to pass string array in SQL parameter to IN clause in SQL
  32. SQL update query using joins
  33. How to update two tables in one statement in SQL Server 2005?
  34. C# Data Connections Best Practice?
  35. How to SELECT FROM stored procedure
  36. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  37. How important is the order of columns in indexes?
  38. Why should I use int instead of a byte or short in C#
  39. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  40. Entity Framework 6 transaction rollback
  41. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  42. varbinary to string on SQL Server
  43. Wildcard search for LINQ
  44. Is there any way to embed power bi reports and dashboards in vb.net or C# desktop application with sql server 2008 database?
  45. separate comma separated values and store in table in sql server
  46. Oracle Parameters with IN statement?
  47. How should I multiple insert multiple records?
  48. Accessing directly a Sql Server Database in Xamarin.Forms
  49. When is it better to store flags as a bitmask rather than using an associative table?
  50. Upload CSV file to SQL server

Leave a Comment