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.
This section provides the information that is required to understand, design, implement, and optimize databases and database snapshots.
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.