Exam objectives in this chapter:
Troubleshoot & Optimize
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: