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

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
You can't. I wouldn't worry too much about it as there are generally many
more things you can be tuning to get peak performance than this.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:u$S2%23cILIHA.6108@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temptable will grow so that it
> does at most 1 memory allocation?
>
sql