Disable non-clustered indexes during data load
Indexes can slow down INSERTS into SQL Server tables, especially in Azure SQL where bulk logged inserts are not available. This procedure can disable and then rebuild all non-clustered indexes on one specified table. Disabling non-clustered indexes is a zero … Continue reading →