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 |
|---|---|
Explains database concepts and includes descriptions of database types, files, filegroups, and log files available in SQL Server. |
|
Provides guidelines, rules, and restrictions you should know when you are designing a database. |
|
Provides guidelines, rules, and restrictions you should know when you are creating, modifying, or deleting a database. |
|
Describes common maintenance tasks that should be performed to keep a database in optimal condition. |
|
Provides guidelines and tips for maintaining database performance and maximizing database operations. |
|
Explains database snapshot concepts and provides specific guidelines for creating and administering database snapshots. |