Thanks Chris,

I was thinking more about it last night (dreaming of sql server? i need a break) and thought of an additional caveat to using sort_in_tempdb. When I rebuild indexes, I loop through each database and rebuild/reorg as needed. Sorting in the tempdb would allow me to only have one large log file and not multiple large log files, one for each database with index operations.

I'm implementing the sort_in_tempdb this weekend in development. we'll see how it goes.