Grant Fritchey (4/30/2014)

---

Tons of stuff has changed. First, did you change the compatibility level on your database to 120? If not, you're using the old statistics with the new optimizer...

Maybe this[/url] might help

😎

Thanks Jeff, this I missed!

😀 that...

He he, somehow my phone didn't show the earlier reply, kind of awkward :hehe:

My first approach would be creating a table with a different name but same structure, copy the...

Quick thought, how about extracting the node to an encrypted table, delete it from the XML and when needed, join the two together?

😎

SQLdude412 (4/30/2014)

---

Thanks for your reply.

The value...

To further on Lowell's point, what is the output of "select datalength(xml_column) from bad_table"? Should be about 70% of the nvarchar conversion normally.

😎

Sean Lange (4/30/2014)

---

Jeremy Brown (4/30/2014)

---

Honestly I don't feel as strongly one way or another. Fine, you want the object name first, go for it. You want the behavior...

Do you have the option of adding a table and use the numeric column to link the two? ASCII code in base 10 is not going to be too useful...

This should get you started

😎

;with XMLNAMESPACES (

'http://www.abc.com/Details' as qsds)

Select

ID

,Version

,Start_Date

,End_Date

,DE.TAILS.value('Age[1]','varchar(50)') AS Age

,MO.DULE.value('.[1]','varchar(50)') AS MModule

,MD.*

FROM Table1 T1

OUTER APPLY...

Paul White (4/30/2014)

---

Eirikur Eiriksson (4/30/2014)

---

FYI: ran the test on the CLR Split, mm's memory optimized version and the lead window function version. Hardly any benefit of using the window function,...

FYI: ran the test on the CLR Split, mm's memory optimized version and the lead window function version. Hardly any benefit of using the window function, 0.001 on average and...

Check out

Stairway to Transaction Log Management in SQL Server[/url]

😎

I do agree but sometimes I get carried away on the cloud of perfection and everlasting solutions:-P

ScottPletcher (4/29/2014)

---

Then expand the initial code to handle 10 bytes (or 20 if you're that worried about it). Yes, I'd be willing to revisit code if the known 5...