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

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

date: Wed, 21 Nov 2007 13:41:34 -0800   author:   DR