The order of TRUNCATE and DROP / DISABLE NONCLUSTERED INDEXES

SQLServerCentral » Latest topics

The order of TRUNCATE and DROP / DISABLE NONCLUSTERED INDEXES

Hi folks... I'm hoping for some guidance on TRUNCATE and NONCLUSTERED INDEXES.  I've been told conflicting information from a couple different DBAs.  Here's the scenario:

I have a table with ~250M records.  Right now it's a daily f

more info...