XML data type in SQL Server 2005 vs. VARCHAR (MAX)

XML data type in SQL Server 2005 vs. VARCHAR (MAX)
As a database administrator, I tend to look closely at performance issues and how to make sure the use of XML does not affect SQL Server performance. In this tip, I'll take you through an example using two tables, one inserted and queried with XML and the other with the VARCHAR (MAX) data type. Take a look at the storage, CPU and I/O results and make the best choice for your SQL Server environment.