I have used this feature a lot in an ETL process where it is very useful. The process is:
1) Extract data from OLTP into staging tables
2) Disable non-clustered indexes
3) Transform and load data
4) Rebuild ALL indexes
Works very well...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs