Oversized XML Docucments in SQL Server 2005

This paper might be useful to some of you:

Pushing SQL Server 2005 Limits - Dealing with Oversized XML Documents
http://www.lacoude.com/docs/public/public.aspx doc=SQL90XML.pdf

This paper reviews XML data handling in SQL Server 2005 and emphasizes the capability of this new version of SQL Server to manipulate extremely large XML documents. Techniques to minimize memory usage and maximize bandwidth throughput are presented. Multiple ways of reading or writing very large XML datasets from or to SQL Server 2005 are demonstrated.

The tests presented in this paper revolve around traditional TPC-A benchmark tests modified to suit the new XML capabilities of SQL Server 2005. Extensive performance tests are designed and the paper concludes with XML benchmarking.

Thanks,

Phil

Philippe Lacoude
http://www.lacoude.com/