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

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?
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:O7YWSdILIHA.3400@.TK2MSFTNGP03.phx.gbl...
> 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 m

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:%23ddnbdILIHA.3400@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temptable will grow so that it
> does at most 1 memory allocation?
>