Exam objectives in this chapter:
Create Database Objects
Create and alter views (simple statements).
Troubleshoot & Optimize
In Chapter 14, you learned about the tools that help you find performance problems. Indexes are mentioned in that chapter many times. This is not a coincidence. Proper indexing is necessary for good performance of your databases. In order to create appropriate indexes, you need to understand how Microsoft SQL Server stores data in tables and indexes, and how it then accesses this data. You learn about this in the longest lesson in this chapter, Lesson 1: Implementing Indexes.
No indexes can help you if you write inefficient queries. In Lesson 2: Using Search Arguments ...