Taming XML query performance using persisted computed columns

Storing data in XML format has presented a conundrum to SQL developers from time to time. While storing it is easy, how does one efficiently extract those pieces of data which are needed from the XML field?

My friend and PFE colleague from Dubai, Batuhan Yildiz, had faced this situation recently. He shares his experiences on the performance impact of retrieving specific data from the XML field, and presents an interesting way of solving the issue by using persisted computed columns. Read the details at his blog here!

Linked content authored by Batuhan Yildiz; posted by Arvind Shyamsundar