blogs.conchango.com

I wrote an article for the September 2006 issue of SQL Server Standard magazine:   The version that was finally published was a very cut down version with minimal code snippets.  This was for obvious reasons; they had to fit the content onto small columns in the magazine.  For the readers who would prefer the more verbose ...

 I’ve seen a few Conchango developers in the past use sp_xml_preparedocument and OPENXML to commit a serialized collection object to the database.  We can do this in SQL Server 2000 and it avoids a round trip to the database for each collection member.  This can mean a huge performance improvement.  Imagine having to call ...