Creating an Index on an XML Fragment in SQL Server
Imagine you are given a table with a column of XML in it and a few million rows of data. Further imagine that you want to write an efficient query using an attribute of that XML in the WHERE clause of your query. A short test scenario describes how I …