XML Queries and Indexing in SQL Server 2005
November 23, 2005[From Developer.com]
SQL Server 2005 is the first version of Microsoft's flagship database to truly embrace XML. True, SQL Server 2000 has some bolt-on XML functionality, but in SQL Server 2005 XML is pervasive. In particular, you can use the new XML columns to actually store XML documents as part of a table. In this article, I'll dig into another part of the XML story: indexing those columns for faster searching.
The article continues at http://www.developer.com/db/article.php/3565996