Wednesday, March 21, 2012

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

How to tell sql server the maximum size my temp table 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:eTPVXgILIHA.3992@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?
>

No comments:

Post a Comment