• GilaMonster - Monday, September 25, 2017 9:00 AM

    kevaburg - Monday, September 25, 2017 8:39 AM

    Is there any gain to be had at all by disabling the nonclustered Indexes?

    There can be. It depends what the load does. A single insert, probably not. Multiple inserts, some updates and some more inserts, probably yes.

    Sounds like a case for extensive testing.  I wouldn't like to plan this sort of data load without it.