SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

Add to Technorati Favorites Add to Google
 

Sparse Columns – ConvertSVtoXML & XMLToResv

By Andy Warren in SQLAndy | 10-08-2009 1:05 AM | Categories: Filed under:
Rating: |  Discuss | 1,806 Reads | 28 Reads in Last 30 Days |2 comment(s)

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!

Comments
 

David McKinney said:

You've spoilt it now!  I've got 3 matches on google, all cause of your little post!

October 15, 2009 3:20 AM
 

Andy Warren said:

I debated throwing in some hyphens, but it's probably the only time I'll be the first to get something into Google!

October 15, 2009 7:15 AM
Leave a Comment
Only members of SQLServerCentral may leave comments. Register now for your free account or Sign-In if you are already a member.