SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

中文(简体)白皮书

在SQL Server 2005中为XML 数据类型优化性能

Microsoft SQL Server 9.0 技术文档

 

发布日期: 200512
作者: Shankar Pal, Babu Krishnaswamy, Vasili Zolotov, and Leo Giakoumakis

 

此文档将研究如何提升Microsoft SQL Server 2005XML 数据类型的查询以及数据修改的性能。为了能够从此文章中学到更多,你需要熟悉SQL Server 2005中的XML 功能。相关背景知识,请参考Microsoft SQL Server 2005中的XML Support 以及MSDN 中的XML Best Practices for Microsoft SQL Server 2005.

 更多信息,请参考白皮书Performance Optimizations for the XML Data Type in SQL Server 2005

 

Comments

No Comments

About denny.lee

Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
Copyright 2008 Microsoft Corporation. All Rights Reserved.