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 ...
Get Designing SQL Server 2000 Databases 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.
