Home All Groups Group Topic Archive Search About

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

Author
21 Nov 2007 10:30 PM
Erland Sommarskog
DR (softwareengineer98***@yahoo.com) writes:
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?

You have posted this question independently to a whole bunch of newsgroups,
and it's not on topic to all. Only post to groups where the question is
relevant, and if you need to target multiple groups, cross-post, don't
multi-post. There is an answer for you in .programming.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button