XML Queries and Indexing in SQL Server 2005

Wednesday Nov 23rd 2005 by DatabaseJournal.com Staff

For the first time, SQL Server 2005 offers a native XML data type. See how you can store and query XML documents as part of a SQL Server table, and how to use XML indexes to make queries against these columns more efficient.

[From Developer.com]

SQL Server 2005 is the first version of Microsoft's flagship database to truly embrace XML. True, SQL Server 2000 has some bolt-on XML functionality, but in SQL Server 2005 XML is pervasive. In particular, you can use the new XML columns to actually store XML documents as part of a table. In this article, I'll dig into another part of the XML story: indexing those columns for faster searching.

The article continues at http://www.developer.com/db/article.php/3565996

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved