# Topics

## Data-tier applications (DAC)

* A data-tier application (DAC) is a logical database entity that defines all of the SQL Server objects - such as tables, views, and instance objects, including logins - associated with a user's database. 
* A DAC is a self-contained unit of the entire database model and is portable in an artifact known as a DAC package, or *.dacpac* which can be deployed to new or existing databases.

## Table Hints

`NO_LOCK` - used to read the data that has been changed but not yet committed to the database.

## Views

The conceptual view is referred to as the total view of a database.

{% embed url="<https://learn.microsoft.com/en-us/sql/relational-databases/performance/execution-plans>" %}