10步驟最佳化SQL Server 資料庫效能

作者從基礎的資料庫索引開始全面講述了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.

Work Issues