Slow bulk insert for table with many indexes

by

You can disable and enable the indexes. Note that disabling them can have unwanted side-effects (such as having duplicate primary keys or unique indices etc.) which will only be found when re-enabling the indexes.

--Disable Index
ALTER INDEX [IXYourIndex] ON YourTable DISABLE
GO

--Enable Index
ALTER INDEX [IXYourIndex] ON YourTable REBUILD
GO

More Related Contents:

  1. SQL Server bulk insert for large data set
  2. Import CSV file into SQL Server
  3. How important is the order of columns in indexes?
  4. Creating an index on a table variable
  5. What are Covering Indexes and Covered Queries in SQL Server?
  6. SQL Server indexes – ascending or descending, what difference does it make?
  7. Does Foreign Key improve query performance?
  8. How to create a unique index on a NULL column?
  9. What’s the difference between a Table Scan and a Clustered Index Scan?
  10. What is wrong with this DB Diagram? [closed]
  11. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  12. SQL Server Subquery a
  13. Efficiently convert rows to columns in sql server
  14. Not equal != operator on NULL
  15. SET NOCOUNT ON usage
  16. How can I get column names from a table in SQL Server?
  17. How can I select the first day of a month in SQL?
  18. T-SQL – Insert Data into Parent and Child Tables
  19. Copy tables from one database to another in SQL Server
  20. error, string or binary data would be truncated when trying to insert
  21. Is it possible to specify condition in Count()?
  22. How to find current transaction level?
  23. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  24. Pivot data in T-SQL
  25. T-SQL – Aliasing using “=” versus “as” [closed]
  26. How to install localdb separately?
  27. Drop all tables whose names begin with a certain string
  28. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  29. UNION ALL vs OR condition in sql server query
  30. Insert all values of a table into another table in SQL

Leave a Comment