Database Features

This section contains the features and tasks associated with databases, database objects, data types, and the mechanisms used to work with or manage data.

In This Section

Databases

Plan Guides

Data-tier Applications

Tables

Cursors

The Transaction Log (SQL Server)

Indexes

Sequence Numbers

Database Checkpoints (SQL Server)

Partitioned Tables and Indexes

DDL Triggers

Back Up and Restore of SQL Server Databases

Views

DML Triggers

Bulk Import and Export of Data (SQL Server)

Stored Procedures (Database Engine)

Synonyms (Database Engine)

Data Compression

Search (SQL Server)

XML Data (SQL Server)

OLE Automation Objects in Transact-SQL

User-Defined Functions

Spatial Data (SQL Server)

Event Notifications

Statistics

Binary Large Object (Blob) Data (SQL Server)

Monitor and Tune for Performance