SQL Server Query Performance Tuning Distilled This second updated edition explains how to design and tune SQL Server applications to cope with ever-increasing workloads. It shows how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. Also covered are issues like index analysis and tuning. Full description