Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

Appendix IX.C. Glossary

ad hoc query:

A query issued infrequently, or on an as-needed basis. Typically ad hoc queries are issued against remote data sources from a SQL Server, but can also be issued against SQL Server from a wide variety of sources. If you have a need to issue queries against a remote data source more often, linked servers are created to simplify the syntax of the ad hoc query. See also linked server.

article:

A database object (such as a table, stored procedure, or view) that is contained within a publication. See also replication.

assembly:

Application logic that is stored in, and managed by, the SQL Server database server, including objects like triggers, CLR software, and stored procedures. Assemblies are written in a .NET language, such a C# or Visual Basic. See also CLR.

attribute:

Information, contained in the form of name-value pairs, located after the start tag of an XML element. See also element; content.

backup:

The process of copying your database's information to another form of media, such as tape or disk. A good backup strategy is vital for any production SQL Server environment. See also full backup; full differential backup.

backup device:

A hardware unit that hosts the media for your database backups. You configure your backup to work with this object. These devices are typically disk or tape drives. See also backup.

checkpoint:

Like any modern relational database management system, SQL Server performs much of its work within high-performance ...