作者从基础的数据库索引开始全面讲述了SQL Server数据库应用程序的性能优化,包括数据库设计和数据访问代码。系列文章如下:
Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using indexing to optimize data access
Top 10 steps to optimize data access in SQL Server. Part II (Re-factor TSQLs and apply best practices)
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on refactoring and applying the TSQL best practices to improve performance.
Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using some advanced indexing techniques and using de-normalizations to optimize data access.
Top 10 steps to optimize data access in SQL Server. Part IV (Diagnose database performance problems)
As part of a series of articles on several data access optimization steps, this article focuses on diagnosing performance problems in SQL Server.