I've written a fair number of blog articles around SQL XML. The query methodologies you've chosen to use within SQL Server are actually less than performance-minded. As odd...