Q:
Estimate SQL Server tempdb space for a query
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.
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.
ASKED:
Aug 3 2009 7:46 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
