Spent some time today working on importing a largish XML file (approx 46MB) into SQL Server. I didn’t spend any time thinking about the best way to do it, just the only way I knew how… read it into memory, parse out the parts you want.. it was taking 90 seconds just to read it into memory. Is there a better way?

This is a pretty cool way to look at your outlook mail.