SQL Server 最优实践
发布日期: 2007年5月25日
作者: Burzin Patel, Sanjay Mishra
投稿人: Kohei Ueda, Michael Thomassy
技术评论家: Stuart Ozer, Prem Mehra, Sunil Agarwal, Artem Oaks, Tengiz Kharatishvili, Mike Ruthruff, Hermann Daeubler, Tom Davidson, Eric Jacobsen, Lindsey Allen
在SQL Server 2005中，任何一个数据表不是采用聚集索引就是通过堆(没有聚集索引的情况下)来进行组织。此白皮书总结了他们之间的优点和缺点，在性能上的区别以及排序为列表(聚集索引)或者采用堆的数据表的其它操作。在六种截然不同的场景中(DML 操作在数据表中执行)测量性能并呈现出详细的报告。此白皮书提供了针对这两种数据表组织形式的优点而建议的最佳实践，同时还提供了一些示例。 更多信息，请参阅白皮书Comparing Tables Organized with Clustered Indexes versus Heaps
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
|
|
