Queries are one of the fundamental tools for manipulating data within SQL server, and knowledge of them is a necessity. This book uses a focused and practical approach to provide you with the most efficient methods to employ with queries. It focuses on the means SQL Server provides to understand the cost of a query, and provides recommendations for ways to remedy poorly-performing queries.

All the information provided is based on the author's real-world experience and highlights the most cost-effective situations to everyday use of SQL Server. He details the steps that you can follow to troubleshoot and resolve SQL query performance.

• How to identify problematic SQL queries
• How to analyze a query execution plan
• How to evaluate the effectiveness of the current indexing techniques
• How to evaluate the effectiveness of statistics
• How to analyze and avoid stored procedure recompilation
• How to analyze plan caching
• How to analyze and minimize blocking
• How to analyze and avoid deadlocks
• How to analyze the cost of using a specific cursor type

Contents

• SQL Query Performance Tuning
• System Performance Analysis
• SQL Query Performance Analysis
• Index Analysis
• Index Tuning Wizard
• Bookmark Lookup Analysis
• Statistics Analysis
• Fragmentation Analysis
• Execution Plan Cache Analysis
• Stored Procedure Recompilation
• Query Design Analysis
• Blocking Analysis
• Deadlock Analysis
• Cursor Cost Analysis
• Database Connection Performance Issues
• Database Workload Optimization
• Scalability Scenarios