sqlenforcer (8/27/2014)
If there is fragmentation in some of the indexes being used in a multi-table join query, would that cause TEMPDB to grow?
You're experiencing heavy tempdb usage during execution of a query. Rewriting the query may reduce or even eliminate tempdb usage: the execution plan (actual, not estimated) for the query is the first place to look for potential improvements. If you can post an actual execution plan here - as a .sqlplan file attachment - folks will provide you with suggestions for improvement.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden