Table Variables

[jonwolds]

What would happen if you tried to populate a table variable which requires more memory than is currently installed on the server? How would SQL Server deal with this?

 

[EdwinGene]

If your table is so large that it will gobble up all your memory, you may want to consider using a tempdb table (#TableName).

 

[ks2000]

What would happen if you open too many applications in a system equipped with low memory ???

Good Luck
Gopala Krishna Kakani

 

[jonwolds]

Gopala,

Would the swap file come into use?

Answering a question with a question isn't that helpful.

Jon

 

[Catadmin]

I think SQL Server just freezes if you try and do more with it than you have physical memory for. It'll probably bring the entire OS to its knees.

First, look at redoing your query that is populating your table datatype. Second, remove any unnecessary programs / services from your machine. Third, buy more memory for your machine if you haven't already maxed it out.

Fourth, buy a new server with better RAM and more processors so it can handle parallelism (Hyperthreading).

Fifth, take off for the rest of the day, have a beer and call it work well done. @=)



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!