O'Reilly logo

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage

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

Chapter 14. Using Tools to Analyze Query Performance

Exam objectives in this chapter:

  • Troubleshoot & Optimize

    • Optimize queries.

Writing queries requires basic T-SQL knowledge; writing well-performing queries needs much more advanced knowledge. However, Microsoft SQL Server 2012 helps you in this learning process. SQL Server exposes information about query execution, like amount of disk IO and CPU time needed to execute the query, detailed execution steps, missing indexes and indexes that are not used, and much more. In this chapter, you learn how to use the query execution information exposed by SQL Server.

Lessons in this chapter:

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