Why This Chapter Is Important

The most attractive application can be extremely frustrating to use if its performance is less than acceptable. As a developer, you must try to ensure that the SQL Server is as lean and efficient as possible.

This chapter focuses on several techniques for improving performance. Probably one of the easiest ways to improve performance is to modify the hardware and software environment within which SQL Server operates. You'll begin by learning how the hardware that you select influences the performance of your application.

By following the guidelines covered in this chapter, you can help ensure that you are not inadvertently introducing bottlenecks into your database and, therefore, your application. Although any one ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.