Saturday, February 9, 2008

T-SQL commands vs. XML AUTO in SQL Server

T-SQL commands vs. XML AUTO in SQL Server
As a DBA, I tend to look at performance issues and therefore would like to make sure that performance will not be affected by the use of XML (Extensible Markup Language). In this first article of a series, I'll show performance implications by comparing the XML AUTO function with the standard T-SQL commands. In my testing process I will cover only a small and basic portion of the XML AUTO functionality. It is always recommended you test the XML functions that you intend to use, in your own environment. ...

No comments: