Bob Beauchemin said no:

http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/edf53293-d8f5-4a3c-b395-d9d53d255dd6

I see the issue now...I assumed the query was telling us something specific about the section of VAS not allocated to the buffer pool, as set by using the -g...

Per the original post the DB server in question has 120GB physical RAM.

That's beside the...

asso.al-hamawandi (4/18/2011)

---

I had the same problem in the SSIS 2008 data flow package . I had a CSV (comma delimited) source data with one of the columns data quoted with...

Here is why it looks odd to me. If he truly has 8,442,427,040 KBs of VAS free that translates to ~8 Terabytes. Is my math wrong? Or am I being...

In your earlier post you...

I am excluding the "XML PATH" method from consideration as a generally accepted way to solve the group string concatenation problem. The "XML PATH,TYPE" method outperformed it in most cases...

Originally I was not going to include the "XML PATH" method considering the method escapes the five characters shown in an earlier post. I thought think it less useful than...

Results attached.

Thanks mister.magoo, those are the goods!

Jeff Moden (4/15/2011)

---

opc.three (4/15/2011)

---

Thanks. Sorry if my last set of results were confusing.

...

...

Here are my results after making those changes for two different size sets...

Tomas Bergvall (4/18/2011)

---

-> opc.three

I'm not entirely sure of how to view the MemToLeave setting but I tried this post http://www.johnsansom.com/index.php/2009/03/sql-server-memory-configuration-determining-memtoleave-settings/#axzz1JsE4avf6

and got the following result from the SQL. Is it possible...

Agreed on procs, I think it is seen as a black box. It's not like T-SQL where it can be broken down by statement. Just throwing it out there in...

Terminology gents...internal vs. external multi-threading perhaps?...in this case .NET multi-thread != SQL Server parallellism...different scopes. Using a CLR method does not prevent SQL Server from employing parallelism in a query...

Craig Farrell (4/15/2011)

---

Awww, OPC, if I didn't know better, I'd say you weren't...

Dup post...