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...

I haven't tried them myself but a 64-bit Jet<edit>-alternative</edit> driver was released: http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

Fine...into rabbit hole 🙂 What is your MemToLeave setting on both instances? -g on your startup options.

I do not think this is related to SQL Server. I suspect it is the Excel driver that is inferring your data types and causing your data to be munged.

The...

I have looked around for a solution using TYPE but have come up empty...what is it that you know and why have you been holding out on us? 😀

I...