I

Index A database object that provides for faster searches on data tables. Indexes may be clustered, nonclustered, or full-text in SQL Server 2008.

INNER JOIN The Transact-SQL clause used to join to separate tables together in a query statement. An INNER JOIN only includes rows that exist in both the first and second named tables in the statement.

INSERT A SQL command used to add data to a SQL Server database table.

Integration Services An optional service that allows for data extraction, transformation, and loading (ETL). Also known as SQL Server Integration Services or SSIS. SSIS is required for the creation of database maintenance plans.

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.