I


IDE

Integrated Development Environment. BIDS is an example of an IDE. The main advantage of an IDE is that it combines all the tools a user needs to create, debug, and maintain a project.

Impersonation

The ability of a principal to assume the security context of another principal.

Index

A SQL Server database object that is used primarily to speed up data access. Also used by SQL Server as a means of enforcing uniqueness.

Index fragmentation

A process that degrades performance because of data not being contiguous as a result of data being modified.

Indexed view

A view that has been computed and stored. You index a view by creating a unique clustered index on it.

INSTEAD OF trigger

A SQL Server trigger that fires before the DML operation.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net