Introduction

This chapter covers some of the more advanced aspects of the physical database design. Of particular interest to anyone preparing for the exam will be the discussion of schema binding and data partitioning because these two topics represent functionality that has been provided over and above the previous version of SQL Server. You can certainly expect questions on schema binding and data partitioning when you take the exam. Also, traditional topics like views, with this version's idiosyncrasies, will be explored.

We will also explore various technologies that exist in handling multiple server environments. Knowing what each technology offersas well its restrictionshelps you adapt a database system applied across multiple machines. Considerations for controlling data alterations, having the data available when needed, and responding to queries in a timely manner will be the aim of questions within this area of the exam.

In preparing properly for some of these more advanced topics, you must ensure that you have a thorough understanding of the variety of objects and technologies available within the realm of physical design. Know what each technique accomplishes (advantages) and also watch out for associated pitfalls (disadvantages).

In many aspects of the database server, the interaction between SQL Server and the OS (operating system) is crucial. Some of the physical design concepts that are discussed point out the role that the OS performs and the reason for its participation.