Attached (zipped) actual execution plan when running Brad's code:

declare @CSVList varchar(8000)

select @CSVList=coalesce(@CSVList+',','')+csvparameter

from (select top 10 csvparameter from csvtest) x

declare @ProductID int, @ProductName varchar(50), @SalesOrderID int, @OrderDate datetime, @TerritoryName varchar(50);

select @ProductID=d.ProductID...

Jeff Moden (9/19/2010)

---

Would some of you other good folks run this code and post the results please? We need both 2k5 and 2k8 runs for anyone willing to participate...

Jeff Moden (9/19/2010)

---

Again, still in the "I don't know so be gentle with me" mode, why is it then that you have to run it a couple of times to...

Version 2 results...:satisfied:

Jeff Moden (9/19/2010)

---

Because I honestly don't know, let me ask if the SQLCLR will "uncache" like an old execution plan might and, if it does, will it "revert" back to...

Jeff Moden (9/19/2010)

---

Nah... my apologies, Paul. I wouldn't make anyone read the whole script to figure out what they need to do to do ME a favor. That's...

I think I see what...

Mark-101232 (9/19/2010)

---

The difference on mine is far less pronounced

Tally:

Table 'Tally'. Scan count 10000, logical reads 30000, physical reads 0

Table 'CsvTest'. Scan count 1, logical reads 774, physical reads 0

CPU time...

For anyone wanting to see how a SQLCLR implementation compares to the other tested methods on this dataset, here's my slightly-tweaked version of Adam Machanic's string splitter: (source code attached)

CREATE...

Ok, these are the results for the unmodified script. Total execution time 19 min 11 sec.

Paul

My results attached. Total run time 5 min 04 sec.

(Pentium 4m Processor @2GHz - SQL Server 2008 x86 Dev)

Sorry I've done this slightly backwards: this run includes one of...

Darn time zones. Jeff, the script has a comment in it to say that Profiler should be running:

--=====================================================================================================================

-- Run the functions (Profiler turned on...

:blush:

Hmm. How'd I miss this thread? :w00t:

Jeff Moden (9/18/2010)

---

Actually, the triangular join thread that leads to is even more...