Luis Cazares (3/18/2016)

---

Eirikur Eiriksson (3/18/2016)

---

Luis Cazares (3/18/2016)

---

Define "just after the full backups". It happens...

Jeff Moden (3/18/2016)

---

Goldie Lesser (3/18/2016)

---

I use Jeff's function all the time, and I can't...

mburbea (3/18/2016)

---

Sadly, I don't have access to a box with 2016 at the moment. But Here is a quick summary of the effect of the traceflag on my test script.

without...

The traceflag 8690 in the test set generation even makes the case worse for the new string_split function, by the looks of it it was benefiting more from the consistent...

mburbea (3/18/2016)

---

see this post from Paul White :

http://www.sqlservercentral.com/Forums/FindPost1570980.aspx

Paul White (5/14/2014)

---

Is everyone running Jeff's original/updated test rig from the article to get these results?

If so, you might not be testing what...

Luis Cazares (3/18/2016)

---

Define "just after the full backups". It happens when the query is...

Did read Aaron's post, thanks again

😎

Goldie Lesser (3/18/2016)

---

I use Jeff's function all the time, and I can't even think...

Luis,

you might be chasing Red Herrings here, does this happen just after the full backups?

😎

Eric M Russell (3/18/2016)

---

Eirikur Eiriksson (3/18/2016)

---

Easy enough, if differential backups are consistently 0 in content and no...

Easy enough, if differential backups are consistently 0 in content and no connections are made to the...

mburbea (3/18/2016)

---

Can you post your test script? I suspect that since delimited8k did so well and string_split did so poorly, this might be related to that optimization that can be...

Here is a more complete example with some error handling and listing of the tables with the date extracted from the name.

😎

USE tempdb;

GO

SET NOCOUNT ON;

--http://www.sqlservercentral.com/Forums/FindPost1770476.aspx

-------------------------------

-- DATE SATAMP THE TABLE

-------------------------------

DECLARE @TABLE_NAME...

pbo71465 (3/17/2016)

---

Hi Forum,

I'm creating a file each day that is created as follows;

[/Select a,b,c, INTO dbo.MyResults from Table1 quote]

I would like to keep each days file so I need a...

Just added the string_split function to Jeff's harness and Ouch :pinch:, what a mess! Not only is it slower than anything else in the harness, the Lead() version comes second...