SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Installation Planning Planning an installation includes discovering current server utilization levels, determining hardware requirements for the new SQL Server 2008 servers, and formulating a time-based plan for implementation.

SQL Server Architecture It is essential that you understand the architecture of any product if you are to implement it successfully. The SQL Server architecture includes the database system components, data access methods, data write methods, and deployment features.

Data Access The data access model, in SQL Server, is based on memory buffers. Data is read into the memory buffer and is not removed until space is needed. This behavior increases the likelihood that requested data will already exist in ...