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.
The ability of a principal to assume the security context of another principal.
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.
A process that degrades performance because of data not being contiguous as a result of data being modified.
A view that has been computed and stored. You index a view by creating a unique clustered index on it.
A SQL Server trigger that fires before the DML operation.