O'Reilly logo

Microsoft SQL Server 2014 Query Tuning & Optimization by Benjamin Nevarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required