I wouldn't recommend them to off on tempdb, at least not the Auto Create. Can you switch them on and try your query again. Please attach the new query plan.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]