Databases

A database in SQL Server 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.

In This Section

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.

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

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.