Using XML in SQL Server

Investigating the possibilities around storing and retrieving native XML data in SQL Server...

• XML Support in SQL Server 2005
  
• XML Best Practices for Microsoft SQL Server 2005
• XQuery Against the xml Data Type
• XQuery Basics 
• Performance Optimizations for the XML Data Type in SQL Server 2005

... and looking into table partitioning

• Partitioned Tables and Indexes in SQL Server 2005
  
• Planning Guidelines for Partitioned Tables and Indexes
• Designing Partitions to Manage Subsets of Data