> For the complete documentation index, see [llms.txt](https://dailyjournal.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dailyjournal.gitbook.io/notes/databases/relational-databases/microsoft-sql-server/topics.md).

# 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>" %}

{% embed url="<https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server>" %}

{% embed url="<https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms190805(v=sql.105)?redirectedfrom=MSDN>" %}

{% embed url="<https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/ms345124(v=sql.90)?redirectedfrom=MSDN>" %}

{% embed url="<https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver17>" %}