I enjoyed reading your article. Thanks for sharing it and providing the material.

I downloaded your code and tried adding an option to do an import via SQLXML parameter into...

The last time I had to move a heavily used database to a new server as part of an upgrade to SQL 2005, I took a full backup, restored it...

If you are running SQL 2005 add the index below and see what plan the engine picks...

create

nonclustered index IX_Exam_name on...

I have worked at Microsoft for over 5 years and it is a great place to work.  It's a big company with numerous groups and opportunities.   Like every company you, do have...