Microsoft SQL Server 2014 Query Tuning & Optimization

Introduction

This book covers query tuning and optimization in SQL Server and gives you the tools and knowledge necessary to get peak performance from your queries and applications. We mostly relate query optimization with the work performed by the query optimizer in which an efficient execution plan is produced, although sometimes we may not be happy with its query execution performance and may try to improve it by performing additional changes—or what we call “query tuning.” However, it is important to understand that the results we originally get from the query processor will greatly depend on all the information we feed it—for example, our database design, the defined indexes, and even some configuration settings. There are many ways in which ...