Re: How to tell sql server the maximum size my temp table will grow so that it does at most 1 memory allocation?
- From: "Günter Prossliner" <g.prossliner/gmx/at>
- Date: Tue, 27 Nov 2007 09:06:33 +0100
Hello!
This is a newsgroup for the CLR (Common Language Runtime). It has nothing to
do with SQL-Server.
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
.
- Prev by Date: is there any speed difference between a TVF CLR that returns an array vs yield as each result is ready? e.g. does returning the array all at once cause sql server to allocate more efficiently?
- Next by Date: Re: How to get base data type for enum via reflection
- Previous by thread: is there any speed difference between a TVF CLR that returns an array vs yield as each result is ready? e.g. does returning the array all at once cause sql server to allocate more efficiently?
- Next by thread: Re: How to get base data type for enum via reflection
- Index(es):
Loading
