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

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 (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.clients microsoft.public.sqlserver.clients

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