O'Reilly logo

Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases by Peter Ward Orin Thomas and boB Taylor

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 10. Indexes and Concurrency

Exam objectives in this chapter:

  • Implement and maintain indexes.

  • Identify and resolve concurrency problems.

As a database administrator, much of your day-to-day work involves making sure your database is performing well and can accommodate the desired number of concurrent users. In this chapter, you examine the concepts of indexes and how they can help solve performance issues. You also examine factors that affect concurrency.

Lessons in this chapter:

Before You Begin

To complete the practice exercises in this chapter, you must have:

  • Microsoft SQL Server 2012 Enterprise edition installed.

  • The AdventureWorks2012 database ...

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