Nice find about the time measurement method so strongly affecting the results. I honestly never took much notice to this, even while aware of better ways of measuring IO statistics...

dwain.c (7/6/2012)

---

Jeff,

I just scanned all 35 pages of this discussion thread seeking the revised string splitter but unfortunately was unable to find it posted by you.

Can you point me to...

Not having worked with it, I did read some articles last year and was totally horrified by the language specifics and couldn't phantom somone getting language basics so wrong! A...

In SQL Server 2008, there is a query hint that circumvents optimization for specific values:

option( optimize for unknown )

This results in plans that are value agnostic and deliver more constant...

The new licensing model for SQL Server 2012 model isn't very encouraging to the company I work for to make a switch to this version. But we did made it...

SQL Kiwi (5/22/2012)

---

peter-757102 (5/22/2012)

---

As for bad performance with some implementations, please try to bench with option( maxdop 1) too as there exists a bug in SQL Server 2008 and...

Too bad (for me) this new round cames at a bad time as I will be too bussy this week to particpate in this round of challenges.

As for bad performance...

Jeff,

With runaway generation of rows I do not mean these rows end up in the result or are part of additional processing by the consuming parts of the query. But...

Jeff Moden (5/10/2012)

---

I did miss that. Thank you for the update.

Looking back in this thread and switching gears a bit, the new improved splitter article did come out. ...

Silly me, you already linked the article I referred to and in one test (the fastest) had the dateparts stored in the table. This removed any date logic overhead that...

Not sure if your testing caught my...

Can't say I am surprised by the outcome as everything that is converted to a varchar/string and back is bound to be inefficient.

The datetimeform parts function doesn't have this conversion...

I know of bcp, and it is (convenience wise) for export a far...

rmechaber (5/3/2012)

---

peter-757102 (5/3/2012)

---

They are unable to model their data properly and often do not handle escaping well, causing errors in individual elements. But XML escaping is extremely simple and requires...

Alex Gay (5/3/2012)

---

XML is a solution looking for a problem. The big mistake is thinking that data interchange is the problem. I have a data file to send...