Jeff Moden (6/28/2016)
Steve Jones - SSC Editor (6/28/2016)
Jeff Moden (6/25/2016)
From the Article:
“This doesn’t work like it used to.”While I agree that it probably has fewer bugs that previous releases, this one broke a whole lot of code where people used XML for purposes of concatenation according to some.
You'll have to provide a reference. I haven't seen this at all, nor can I find anything in searches. Perhaps I'm not looking in the right places, but I'd like to see a repro before I believe this.
http://www.sqlservercentral.com/articles/STRING_SPLIT/139338/
See the section under "Creating Large Scale Test Data"
Where specifically? The only comment I can see in that section that refers to something broken is the CE changes to 2014 which changed the plan and resulted in non-random data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability