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?
No. Fragmentation has to do with the arrangement of pages on disk. It has no relevance once pages are in memory, which they will be when the query execution engine is using them. By the time the rows get to the point of being added to work tables, their physical storage details are irrelevant.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability