Blog Post

Sparse Columns – ConvertSVtoXML & XMLToResv

,

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the  Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.

I’d welcome more info on the functions, but for me the more interesting part was the zero matches!

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating