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

#1

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

#2

Hello!

This is a newsgroup for the CLR (Common Language Runtime). It has nothing to
do with SQL-Server.

Quote:

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

You cannot. But with the SQL-Server Storage Engine Architecture it is not
really nessersary.

You may use Bulk Commands / Utitlies to insert lange amount of data.

GP

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

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

Dotnet Framework (CLR) microsoft.public.dotnet.framework.clr

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

Re: How to tell sql server the maximum size my temp table will grow so that it does at most 1 memory allocation? - 11-27-2007 , 03:06 AM