You're on the right track, you need to find the right balance between your max memory setting and MemToLeave.

You could look at using SQLCLR to call out to the service, but that would open a whole can of worms regarding security.

Why can't the service retrieve the XML from...

Krasavita (6/27/2011)

---

So, I have 12Gb and need to switch my max memory to 10600 MB right? Is that would fix my problem? I need to...

I cannot reproduce this behavior. Can you please post some sample code to show that SQL Server changed your data?

CREATE TABLE dbo.xml_test (xml_data XML) ;

INSERT INTO dbo.xml_test

...

You're welcome 🙂

Right-click My Computer and go to properties.

The first line of the article says it all. Not sure what I can say better than Glenn to convince you.

CREATE TABLE dbo.table1 (A CHAR(1), B CHAR(1)) ;

GO

INSERT INTO dbo.table1

(A, B)

VALUES ('A', 'B'),

...

The same guidelines apply.

It depends on how you...

All of the code samples in Books Online use the AdventureWorks DB. It's a great place to start:

http://technet.microsoft.com/en-us/library/ms130214.aspx

crackbridge (6/27/2011)

---

Look friends, I'm sorry if someone felt wrong it was just in save of time and richness of knowledge.

I'll be shorter, what I say, forum is not to post...

You're welcome 🙂

Consider moving to 64-bit soon. It does not suffer from the VAS issue you;re experiencing.

2.This is production server,how...

Krasavita (6/27/2011)

---

I just ran

Total avail mem, KBMax free size, KB

87316 ...

Sweet, thanks, found a new toy 🙂