Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to tell sql server the maximum size my temptable will ..

  
   Database Forums (Home) -> Clustering RSS
Next:  How to tell sql server the maximum size my tempta..  
Author Message
DR

External


Since: Oct 23, 2007
Posts: 27



(Msg. 1) Posted: Wed Nov 21, 2007 1:41 pm
Post subject: How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?

 >> Stay informed about: How to tell sql server the maximum size my temptable will .. 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 2) Posted: Wed Nov 21, 2007 5:49 pm
Post subject: Re: How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" wrote in message

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

 >> Stay informed about: How to tell sql server the maximum size my temptable will .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Could not set working set size to 1168512 KB - hello, We're running W2000 sp4 fr/ SQL 2000 SP3 fr and get error 17122 in the application event log every time SQL is brought up. The error text reads "initdata: Warning: Could not set working set size to 1168512 KB". What does this really mea...

SQL Server and File Server - Hi, Can someone give me an opinion with installing SQL Server 2005 with clustering and use those servers for file servers at the same time. Thanks Jacques

How to do clustering in SQL Server 2000? - Hi We Want to do clustering of 2-3 SQL Servers. I m completely new to this concept. Any pointers around the same are most welcome. Regards Priyanka

MSDTC with SQL Server 2000 - Hi, I have a three nodes cluster with Win 2003. On that I have four SQL intances. MSTDC is installed on the Quorum. When a failover happens, the SQL groups start before MSDTC and that create a problem with the transactions after. To assure a good..

New Cluster server - Hi all, This is the first time i am experience cluster server for sql server(no SAN). My question is what id the best way to configure partition the hard drive for performance and security. Log and data files are needed in separate physical..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]