When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,

"It really helped us isolate where we were experiencing a bottleneck" - John Q Martin, SQL Server DBA. Get started with SQL Monitor today to solve tricky performance problems - download a free trial