Database - MS Sql Server
How to estimate the amount of space that a query uses in tempdb?
I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like:
1. Columns retrieved
2. Join conditions
3. Indexes on the tables.