How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?

Tech-Archive recommends: Speed Up your PC by fixing your registry



How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?


.