Introduction

Every organization has data close to its heart. Storing and caring for data are the roles of SQL Server. SQL Server s robust RDBMS architecture supports hosting multiple, distinct databases and, since version 7.0, provides native file system support, simplifying the management of database files. Planning for the location and growth of these files is an important process in designing and creating your database.

This chapter discusses the architecture of SQL Server, various storage systems for SQL database files, and how to design an efficient database file structure for your application.

Creating databases in SQL Server can be as simple as responding to dialog box prompts using the Create Database Wizard or as configurable as the T-SQL CREATE DATABASE statement. We review the options available for creating databases and configuring options such as database support for various collations, a new option in SQL Server 2000. Several features are available for tasks such as moving databases and supporting database growth with file autogrow and multiple data files.

Before you can begin creating the physical database and storage files, you need to understand the database structure and its requirements. This chapter reviews the architecture of SQL Server as well as the modeling techniques and tools available to design and implement your database solution. Having a clear understanding of the database model is essential to planning and modifying your physical database.