O'Reilly logo

Designing SQL Server 2000 Databases by Syngress

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4

Designing and Creating SQL Server Databases

Solutions in this chapter:

 SQL Server 2000 Architecture

 Creating SQL Server Databases

 Creating and Configuring Your Database

 Database Modeling Tools

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required