SQLServer调优系列,NND

1. SQLServer索引调优实践

SQLServer索引调优实践: http://www.cnblogs.com/Mainz/archive/2009/10/28/1591501.html

SQLServer索引调优实践(2) - 索引覆盖: http://www.cnblogs.com/Mainz/archive/2009/10/30/1593102.html

SQLSERVER调优案例: http://zhouwf0726.itpub.net/post/9689/404295

SQLSERVER索引优化二: http://www.cnblogs.com/wangdaye/archive/2010/03/22/1691699.html

SQL SERVER索引优化系列之一:工作原理&聚簇索引|非聚簇索引: http://www.cnblogs.com/tmyh/archive/2010/09/29/sqlindex_01.html

SQL SERVER索引优化系列之二:索引性能考虑: http://www.cnblogs.com/tmyh/archive/2010/09/29/sqlindex_02.html

SQL SERVER索引优化系列之三:填充因子: http://www.cnblogs.com/tmyh/archive/2010/09/29/sqlindex_03.html

 

2. SQLServer的数据存储单元

http://tech.ddvip.com/2008-11/122785437395880.html

http://tech.cncms.com/shujuku/mssql/101045.html

http://www.lmwlove.com/ac/ID670

 

3. Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)

http://www.codeproject.com/Articles/37089/Top-10-steps-to-optimize-data-access-in-SQL-Server

 

4. SqlServer索引及优化详解       

http://blog.csdn.net/china2010pan/article/details/6953498

 

5. T-SQL查询高级—SQL Server索引中的碎片和填充因子

http://www.cnblogs.com/CareySon/archive/2012/01/06/2313897.html

 

6. 重新组织和重新生成索引的区别

http://www.liyg.net/archives/779

转载于:https://www.cnblogs.com/fcguoan/archive/2012/05/16/2505539.html