tripleAxe (9/15/2016)

---

Here is the UNION ALL query using a temp table so that we can have one pass at the input table as suggested by The Dixie Flatline in an...

There is another way of getting a single scan plan and that is to use an inline tally table, here are two harnesses, 5 and 50 columns respectfully.

😎

5 column harness

USE...

Here is a 50 column test harness and the results on my old laptop (2nd Gen i5)

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

-- TEST HARNESS

DECLARE @timer TABLE (

T_TXT...

Thank you Tomaž for this nice write-up, very good indeed!

😎

Added the Union All to the test harness

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

-- TEST HARNESS

DECLARE @timer TABLE (

T_TXT VARCHAR(50) NOT NULL

...

Here is a simple test harness which you can use

😎

USE TEEST;

GO

SET NOCOUNT ON;

-- TEST HARNESS

DECLARE @timer TABLE (

T_TXT VARCHAR(50) ...

Jeff Moden (9/14/2016)

---

Eirikur Eiriksson (9/14/2016)

---

Jeff Moden (9/14/2016)

---

Not guaranteed to be true, though. Because of...

Almost there, just needed a little adjustment 😉

😎

SELECT

ACC.AccountUID AS 'AccountUID'

,ACC.AccountID AS 'AccountID'

,(SELECT

...

Phil Parkin (9/14/2016)

---

I try...

Not only is it more contorted but also...

:pinch: Memory failure :pinch:

The cross apply will produce...

mahi123 (9/14/2016)

---

Thanks for your help..

But requirement is need to generate XML in one folder , and whenever i open the XML XML need to have a header with <?xml version="1.0"...

Hi Phil,

are you running the latest version with the latest updates? Had this problem few updates ago and after one update it went away.

😎

drew.allen (9/14/2016)

---

I was actually wondering whether it would be more efficient to sum before the CROSS APPLY or after. I ran a simple test, but it was impossible to...

Jeff Moden (9/14/2016)

---

Not guaranteed to be true, though. Because of the translations, as unlikely...