作者从基础的数据库索引开始全面讲述了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
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.
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.