Export (0) Print
Expand All

Databases (Database Engine)

A database in SQL Server 2005 is made up of a collection of tables. These tables contain data and other objects, such as views, indexes, stored procedures, user-defined functions, and triggers that are defined to support activities performed with the data. The data stored in a database is typically related to a particular subject or process, such as inventory information for a manufacturing warehouse.

This section provides the information that is required to understand, design, implement, and optimize databases and database snapshots.

Topic Description

Understanding Databases

Explains database concepts and includes descriptions of database types, files, filegroups, and log files available in SQL Server 2005.

Designing Databases

Provides guidelines, rules, and restrictions you should know when you are designing a database.

Implementing Databases

Provides guidelines, rules, and restrictions you should know when you are creating, modifying, or deleting a database.

Maintaining Databases (Database Engine)

Describes common maintenance tasks that should be performed to keep a database in optimal condition.

Optimizing Databases

Provides guidelines and tips for maintaining database performance and maximizing database operations.

Database Snapshots

Explains database snapshot concepts and provides specific guidelines for creating and administering database snapshots.

Community Additions

ADD
Show:
© 2014 Microsoft