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

#1

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

#2

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 (AT) yahoo (DOT) com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation? - 11-21-2007 , 03:41 PM

Re: How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation? - 11-21-2007 , 04:49 PM