Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

6. Techniques to Improve Query Performance

Chapter 6. Techniques to Improve Query Performance

After you have designed your database and application, you typically want to make sure that it can deliver the performance that your application users demand. This chapter covers what you can do to find performance problems in your database and how to solve the problems you uncover. Microsoft SQL Server 2008 is an extremely capable and efficient database engine, but it still requires you to do some performance tuning if you have a very large database, complicated queries, a high number of queries being served, or a combination of these factors.

Exam objectives in this chapter:

  • Create and alter indexes.

  • Implement partitioning solutions.

  • Control execution plans.

  • Capture execution plans.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint