Dave

There are 2 main methods to work with XML Data in SQL.

OpenXML

• Requires error handling to ensure paired usage of sp_xml_preparedocument and sp_xml_removedocument
• Limits maximum memory usage for XML parsing of an instance to 1/8^th of allocated SQL memory
• Performs better in many cases than “Nodes” method on low end CPUs
• Pattern to be used:

SET NOCOUNT ON

DECLARE @ErrorMessage NVARCHAR(4000)
DECLARE @ErrorSeverity INT

...

Tags: ms sql, performance, sql, tsql, xml

Categories

Uncategorized

I received an interesting, and rather funny if I may say, message through LinkedIn today from a recruiter. It had a lot of claims of "Cutting Edge" and "Bleeding Edge" along with a buzzword laden description of the opportunity.

After a long day of several recruiters emailing and then calling me immediately after (while I was reading the email on my phone no less) my irritation drove me to help this recruiter improve his skill-set.

Below was my response. ...