1 Table of Contents: “...1. Query Performance Tuning -- 2. Execution Plan Generation and the Query Optimizer -- 3. Methods...”

2 “... of query execution and how that execution has changed over time. Query Store helps to identify queries...”

3 “... of query execution and how that execution has changed over time. Query Store helps to identify queries...”

4 Table of Contents: “..., and Cardinality -- 14. Index Fragmentation -- 15. Execution Plan Generation -- 16. Execution Plan Cache Behavior...”

5 “..., such as Query Store to manage and control execution plans, the automated performance tuning feature set...”

6 Table of Contents: “... -- Fragmentation Analysis -- Execution Plan Cache Analysis -- Stored Procedure Recompilation -- Query Design...”

7 Table of Contents: “...; Inaccurate Statistics; Improper Query Design; Poorly Generated Execution Plans; Excessive Blocking...”

8 Table of Contents: “... Lookup Analysis -- Ch. 7. Statistics Analysis -- Ch. 8. Fragmentation Analysis -- Ch. 9. Execution Plan...”

9 Table of Contents: “...; Inaccurate Statistics; Improper Query Design; Poorly Generated Execution Plans; Excessive Blocking...”

10 Table of Contents: “...; SQL Server Documentation; Integration Services Folder; Data Profiler Viewer; Execute Package Utility...”